home *** CD-ROM | disk | FTP | other *** search
| MacBinary | 1994-07-20 | 23.0 KB | [TEXT/ttxt] |
open in: 
MacOS 8.1
|
Win98
|
DOS
browse contents |
view JSON data
|
view as text
This file was processed as: MacBinary
(archive/macBinary).
| Confidence | Program | Detection | Match Type | Support
|
|---|
| 10%
| dexvert
| MacBinary (archive/macBinary)
| fallback
| Supported |
| 1%
| dexvert
| Text File (text/txt)
| fallback
| Supported |
| 100%
| file
| MacBinary II, inited, Wed Jul 20 00:19:33 1994, modified Wed Jul 20 00:19:33 1994, creator SimpleText, type ASCII, 22948 bytes "Napkin Calc READ ME" , at 0x5a24 332 bytes resource
| default (weak)
| |
| 99%
| file
| data
| default
| |
| 74%
| TrID
| Macintosh plain text (MacBinary)
| default
| |
| 25%
| TrID
| MacBinary 2
| default (weak)
| |
| 100%
| siegfried
| fmt/1762 MacBinary (II)
| default
| |
| 100%
| lsar
| MacBinary
| default
|
|
| id metadata |
|---|
| key | value |
|---|
| macFileType | [TEXT] |
| macFileCreator | [ttxt] |
hex view+--------+-------------------------+-------------------------+--------+--------+
|00000000| 00 13 4e 61 70 6b 69 6e | 20 43 61 6c 63 20 52 45 |..Napkin| Calc RE|
|00000010| 41 44 20 4d 45 00 00 00 | 00 00 00 00 00 00 00 00 |AD ME...|........|
|00000020| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000030| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000040| 00 54 45 58 54 74 74 78 | 74 01 00 00 00 00 00 00 |.TEXTttx|t.......|
|00000050| 00 00 00 00 00 59 a4 00 | 00 01 4c aa 52 56 55 aa |.....Y..|..L.RVU.|
|00000060| 52 56 55 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |RVU.....|........|
|00000070| 00 00 00 00 00 00 00 00 | 00 00 81 81 81 46 00 00 |........|.....F..|
|00000080| 4e 41 50 4b 49 4e 20 43 | 41 4c 43 20 31 2e 31 20 |NAPKIN C|ALC 1.1 |
|00000090| 62 79 20 4d 41 43 41 50 | 41 0d 2d 2d 2d 2d 2d 2d |by MACAP|A.------|
|000000a0| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 2d 2d 2d 2d 2d 2d 2d |--------|--------|
|000000b0| 2d 2d 2d 0d 0d 53 6f 2c | 20 79 6f 75 d5 72 65 20 |---..So,| you.re |
|000000c0| 61 73 6b 69 6e 67 20 79 | 6f 75 72 73 65 6c 66 2c |asking y|ourself,|
|000000d0| 20 77 68 61 74 20 63 61 | 6e 20 49 ca 64 6f 20 77 | what ca|n I.do w|
|000000e0| 69 74 68 20 74 68 69 73 | 20 70 72 6f 64 75 63 74 |ith this| product|
|000000f0| 3f 20 57 65 6c 6c 2c 20 | 65 73 73 65 6e 74 69 61 |? Well, |essentia|
|00000100| 6c 6c 79 2c 20 74 68 69 | 73 20 69 73 20 61 20 73 |lly, thi|s is a s|
|00000110| 70 72 65 61 64 73 68 65 | 65 74 2d 6c 69 6b 65 20 |preadshe|et-like |
|00000120| 70 72 6f 67 72 61 6d 2e | 20 49 74 20 6c 65 74 73 |program.| It lets|
|00000130| 20 79 6f 75 20 63 72 65 | 61 74 65 20 73 68 65 65 | you cre|ate shee|
|00000140| 74 73 20 69 6e 20 77 68 | 69 63 68 20 79 6f 75 20 |ts in wh|ich you |
|00000150| 63 61 6e 20 65 6e 74 65 | 72 20 6e 75 6d 62 65 72 |can ente|r number|
|00000160| 73 20 61 6e 64 20 74 65 | 78 74 2c 20 61 6e 64 20 |s and te|xt, and |
|00000170| 70 65 72 66 6f 72 6d 20 | 63 61 6c 63 75 6c 61 74 |perform |calculat|
|00000180| 69 6f 6e 73 20 6f 6e 20 | 74 68 65 20 6e 75 6d 62 |ions on |the numb|
|00000190| 65 72 73 20 79 6f 75 20 | 65 6e 74 65 72 65 64 2e |ers you |entered.|
|000001a0| 20 4f 6e 65 20 6f 66 20 | 74 68 65 20 6d 61 6e 79 | One of |the many|
|000001b0| 20 73 74 72 6f 6e 67 20 | 70 6f 69 6e 74 73 20 6f | strong |points o|
|000001c0| 66 20 4e 61 70 6b 69 6e | 20 43 61 6c 63 20 69 73 |f Napkin| Calc is|
|000001d0| 20 74 68 61 74 20 79 6f | 75 20 63 61 6e 20 68 61 | that yo|u can ha|
|000001e0| 76 65 20 6d 6f 72 65 20 | 74 68 61 6e 20 6f 6e 65 |ve more |than one|
|000001f0| 20 73 68 65 65 74 20 6f | 6e 20 79 6f 75 72 20 73 | sheet o|n your s|
|00000200| 63 72 65 65 6e 20 61 74 | 20 61 20 74 69 6d 65 2e |creen at| a time.|
|00000210| 20 49 74 20 69 73 20 61 | 6c 73 6f 20 66 61 69 72 | It is a|lso fair|
|00000220| 6c 79 20 65 61 73 79 20 | 74 6f 20 75 73 65 2e 20 |ly easy |to use. |
|00000230| 54 68 69 73 20 70 72 6f | 67 72 61 6d 20 64 6f 65 |This pro|gram doe|
|00000240| 73 20 6e 6f 74 20 77 69 | 73 68 20 74 6f 20 70 72 |s not wi|sh to pr|
|00000250| 65 73 65 6e 74 20 69 74 | 73 65 6c 66 20 61 73 20 |esent it|self as |
|00000260| 61 20 d2 73 75 70 65 72 | 20 70 6f 77 65 72 66 75 |a .super| powerfu|
|00000270| 6c d3 2c 20 61 6c 6c 20 | 6b 6e 6f 77 69 6e 67 2c |l., all |knowing,|
|00000280| 20 63 61 6c 63 75 6c 61 | 74 69 6f 6e 20 6d 61 63 | calcula|tion mac|
|00000290| 68 69 6e 65 2e 20 49 74 | d5 73 20 70 75 72 70 6f |hine. It|.s purpo|
|000002a0| 73 65 20 69 73 20 73 69 | 6d 70 6c 79 20 74 6f 20 |se is si|mply to |
|000002b0| 6c 65 74 20 79 6f 75 20 | 72 75 6e 20 61 20 66 65 |let you |run a fe|
|000002c0| 77 20 63 61 6c 63 75 6c | 61 74 69 6f 6e 73 20 6f |w calcul|ations o|
|000002d0| 6e 20 74 68 65 20 66 6c | 79 2c 20 61 6e 64 20 61 |n the fl|y, and a|
|000002e0| 6c 73 6f 20 70 72 69 6e | 74 20 6f 72 20 66 61 78 |lso prin|t or fax|
|000002f0| 20 61 20 6e 69 63 65 20 | 6c 6f 6f 6b 69 6e 67 20 | a nice |looking |
|00000300| 72 65 70 6f 72 74 2e 0d | 0d 49 66 20 79 6f 75 20 |report..|.If you |
|00000310| 6f 6e 6c 79 20 77 69 73 | 68 20 74 6f 20 66 69 6e |only wis|h to fin|
|00000320| 64 20 6f 75 74 20 77 68 | 61 74 d5 73 20 62 65 65 |d out wh|at.s bee|
|00000330| 6e 20 63 68 61 6e 67 65 | 64 20 73 69 6e 63 65 20 |n change|d since |
|00000340| 74 68 65 20 6c 61 73 74 | 20 76 65 72 73 69 6f 6e |the last| version|
|00000350| 2c 20 79 6f 75 20 63 61 | 6e 20 73 6b 69 70 20 74 |, you ca|n skip t|
|00000360| 6f 20 74 68 65 20 65 6e | 64 20 6f 66 20 74 68 69 |o the en|d of thi|
|00000370| 73 20 64 6f 63 75 6d 65 | 6e 74 2e 0d 0d 0d 52 45 |s docume|nt....RE|
|00000380| 47 49 53 54 45 52 49 4e | 47 0d 59 6f 75 20 63 61 |GISTERIN|G.You ca|
|00000390| 6e 20 75 73 65 20 4e 61 | 70 6b 69 6e 20 43 61 6c |n use Na|pkin Cal|
|000003a0| 63 20 66 6f 72 20 66 72 | 65 65 20 66 6f 72 20 31 |c for fr|ee for 1|
|000003b0| 35 20 64 61 79 73 2c 20 | 61 66 74 65 72 20 77 68 |5 days, |after wh|
|000003c0| 69 63 68 2c 20 69 66 20 | 79 6f 75 20 64 65 63 69 |ich, if |you deci|
|000003d0| 64 65 20 74 6f 20 6b 65 | 65 70 20 75 73 69 6e 67 |de to ke|ep using|
|000003e0| 20 69 74 2c 20 77 65 20 | 61 73 6b 20 74 68 61 74 | it, we |ask that|
|000003f0| 20 79 6f 75 20 73 65 6e | 64 20 75 73 20 32 35 24 | you sen|d us 25$|
|00000400| 2e 20 57 68 61 74 20 79 | 6f 75 20 67 65 74 20 69 |. What y|ou get i|
|00000410| 6e 20 72 65 74 75 72 6e | 20 69 73 20 61 20 70 65 |n return| is a pe|
|00000420| 72 73 6f 6e 61 6c 20 75 | 73 65 72 20 49 44 20 74 |rsonal u|ser ID t|
|00000430| 68 61 74 20 79 6f 75 20 | 63 61 6e 20 65 6e 74 65 |hat you |can ente|
|00000440| 72 20 69 6e 20 74 68 65 | 20 52 65 67 69 73 74 72 |r in the| Registr|
|00000450| 61 74 69 6f 6e 20 73 63 | 72 65 65 6e 20 28 74 68 |ation sc|reen (th|
|00000460| 65 20 6f 6e 65 20 74 68 | 61 74 20 73 68 6f 77 73 |e one th|at shows|
|00000470| 20 75 70 20 65 76 65 72 | 79 20 74 69 6d 65 20 79 | up ever|y time y|
|00000480| 6f 75 20 73 74 61 72 74 | 20 4e 61 70 6b 69 6e 20 |ou start| Napkin |
|00000490| 43 61 6c 63 29 2c 20 61 | 6e 64 20 67 69 76 65 73 |Calc), a|nd gives|
|000004a0| 20 79 6f 75 20 74 68 65 | 20 72 69 67 68 74 20 74 | you the| right t|
|000004b0| 6f 20 6f 75 72 20 70 72 | 69 6f 72 69 74 79 20 73 |o our pr|iority s|
|000004c0| 75 70 70 6f 72 74 2e 20 | 55 73 65 72 73 20 6f 66 |upport. |Users of|
|000004d0| 20 73 6f 6d 65 20 6f 66 | 20 6f 75 72 20 6f 74 68 | some of| our oth|
|000004e0| 65 72 20 70 72 6f 64 75 | 63 74 73 20 28 6c 69 6b |er produ|cts (lik|
|000004f0| 65 20 4c 69 73 74 2d 49 | 74 29 ca 63 61 6e 20 61 |e List-I|t).can a|
|00000500| 74 74 65 73 74 20 74 6f | 20 74 68 65 20 66 61 63 |ttest to| the fac|
|00000510| 74 20 74 68 61 74 20 77 | 65 20 74 72 79 20 74 6f |t that w|e try to|
|00000520| 20 70 6c 65 61 73 65 20 | 6f 75 72 20 72 65 67 69 | please |our regi|
|00000530| 73 74 65 72 65 64 20 75 | 73 65 72 73 20 61 73 20 |stered u|sers as |
|00000540| 6d 75 63 68 20 61 73 20 | 77 65 20 63 61 6e 2c 20 |much as |we can, |
|00000550| 61 6e 64 20 61 6e 73 77 | 65 72 20 74 68 65 69 72 |and answ|er their|
|00000560| 20 71 75 65 73 74 69 6f | 6e 73 20 61 73 20 71 75 | questio|ns as qu|
|00000570| 69 63 6b 6c 79 20 61 73 | 20 70 6f 73 73 69 62 6c |ickly as| possibl|
|00000580| 65 2e 0d 0d 0d 47 45 54 | 54 49 4e 47 20 53 54 41 |e....GET|TING STA|
|00000590| 52 54 45 44 0d 57 68 65 | 6e 20 79 6f 75 20 66 69 |RTED.Whe|n you fi|
|000005a0| 72 73 74 20 6f 70 65 6e | 20 75 70 20 4e 61 70 6b |rst open| up Napk|
|000005b0| 69 6e ca 43 61 6c 63 2c | 20 74 68 65 20 66 69 72 |in.Calc,| the fir|
|000005c0| 73 74 20 74 68 69 6e 67 | 20 79 6f 75 20 73 65 65 |st thing| you see|
|000005d0| 20 28 61 66 74 65 72 20 | 74 68 65 20 72 65 67 69 | (after |the regi|
|000005e0| 73 74 72 61 74 69 6f 6e | 20 73 63 72 65 65 6e 29 |stration| screen)|
|000005f0| 2c 20 69 73 20 61 20 62 | 6c 61 6e 6b 20 61 72 65 |, is a b|lank are|
|00000600| 61 2e 20 54 68 65 20 66 | 69 72 73 74 20 74 68 69 |a. The f|irst thi|
|00000610| 6e 67 20 79 6f 75 20 6d | 69 67 68 74 20 77 61 6e |ng you m|ight wan|
|00000620| 74 20 74 6f 20 64 6f 20 | 69 73 20 63 72 65 61 74 |t to do |is creat|
|00000630| 65 20 61 20 6e 65 77 20 | 73 68 65 65 74 20 62 79 |e a new |sheet by|
|00000640| 20 74 61 70 69 6e 67 20 | 6f 6e 20 74 68 65 20 4e | taping |on the N|
|00000650| 65 77 20 62 75 74 74 6f | 6e 2e 20 59 6f 75 d5 6c |ew butto|n. You.l|
|00000660| 6c 20 74 68 65 6e 20 62 | 65 20 70 72 65 73 65 6e |l then b|e presen|
|00000670| 74 65 64 20 61 20 62 6c | 61 6e 6b 20 73 68 65 65 |ted a bl|ank shee|
|00000680| 74 20 69 6e 20 77 68 69 | 63 68 20 79 6f 75 20 63 |t in whi|ch you c|
|00000690| 61 6e 20 65 6e 74 65 72 | 20 61 6e 79 74 68 69 6e |an enter| anythin|
|000006a0| 67 2e 0d 0d 54 68 65 20 | 65 61 73 69 65 73 74 20 |g...The |easiest |
|000006b0| 77 61 79 20 6f 66 20 65 | 6e 74 65 72 69 6e 67 20 |way of e|ntering |
|000006c0| 61 20 66 6f 72 6d 75 6c | 61 20 69 73 20 74 6f 20 |a formul|a is to |
|000006d0| 65 6e 74 65 72 20 61 20 | d2 2d d3 20 69 6e 20 61 |enter a |.-. in a|
|000006e0| 20 62 6c 61 6e 6b 20 63 | 65 6c 6c 2e 20 54 68 69 | blank c|ell. Thi|
|000006f0| 73 20 77 69 6c 6c 20 62 | 72 69 6e 67 20 75 70 20 |s will b|ring up |
|00000700| 74 68 65 20 66 6f 72 6d | 75 6c 61 20 65 64 69 74 |the form|ula edit|
|00000710| 6f 72 20 69 6e 20 77 68 | 69 63 68 20 79 6f 75 d5 |or in wh|ich you.|
|00000720| 6c 6c 20 62 65 20 61 62 | 6c 65 20 74 6f 20 65 6e |ll be ab|le to en|
|00000730| 74 65 72 20 61 20 66 75 | 6e 63 74 69 6f 6e 20 79 |ter a fu|nction y|
|00000740| 6f 75 20 77 69 73 68 20 | 74 6f 20 70 65 72 66 6f |ou wish |to perfo|
|00000750| 72 6d 20 6f 6e 20 74 68 | 65 20 64 61 74 61 20 79 |rm on th|e data y|
|00000760| 6f 75 20 65 6e 74 65 72 | 65 64 2e 0d 0d 41 6c 73 |ou enter|ed...Als|
|00000770| 6f 2c 20 79 6f 75 20 63 | 61 6e 20 70 72 69 6e 74 |o, you c|an print|
|00000780| 2c 20 66 61 78 2c 20 62 | 65 61 6d 20 6f 72 20 6d |, fax, b|eam or m|
|00000790| 61 69 6c 20 61 20 73 68 | 65 65 74 20 6a 75 73 74 |ail a sh|eet just|
|000007a0| 20 61 73 20 65 61 73 69 | 6c 79 20 61 73 20 69 6e | as easi|ly as in|
|000007b0| 20 61 6e 79 20 6f 74 68 | 65 72 20 61 70 70 6c 69 | any oth|er appli|
|000007c0| 63 61 74 69 6f 6e 2e 20 | 4a 75 73 74 20 6d 61 6b |cation. |Just mak|
|000007d0| 65 20 73 75 72 65 20 79 | 6f 75 20 68 61 76 65 20 |e sure y|ou have |
|000007e0| 61 20 73 68 65 65 74 20 | 6f 70 65 6e 20 28 61 6e |a sheet |open (an|
|000007f0| 64 20 75 70 20 66 72 6f | 6e 74 29 20 62 65 66 6f |d up fro|nt) befo|
|00000800| 72 65 20 79 6f 75 20 74 | 72 79 20 74 6f 20 70 72 |re you t|ry to pr|
|00000810| 69 6e 74 20 69 74 2e 0d | 0d 54 68 61 74 d5 73 20 |int it..|.That.s |
|00000820| 69 74 20 66 6f 72 20 74 | 68 65 20 6d 6f 73 74 20 |it for t|he most |
|00000830| 62 61 73 69 63 20 69 6e | 66 6f 72 6d 61 74 69 6f |basic in|formatio|
|00000840| 6e 2e 20 57 65 20 73 74 | 72 6f 6e 67 6c 79 20 72 |n. We st|rongly r|
|00000850| 65 63 6f 6d 6d 65 6e 64 | 20 74 68 61 74 20 79 6f |ecommend| that yo|
|00000860| 75 20 72 65 61 64 20 74 | 68 69 73 20 65 6e 74 69 |u read t|his enti|
|00000870| 72 65 20 6d 61 6e 75 61 | 6c 2c 20 61 73 20 77 65 |re manua|l, as we|
|00000880| 6c 6c 20 61 73 20 74 68 | 65 20 57 41 52 4e 49 4e |ll as th|e WARNIN|
|00000890| 47 20 66 69 6c 65 2e 20 | 42 6f 74 68 20 70 72 6f |G file. |Both pro|
|000008a0| 76 69 64 65 20 69 6d 70 | 6f 72 74 61 6e 74 20 69 |vide imp|ortant i|
|000008b0| 6e 66 6f 72 6d 61 74 69 | 6f 6e 20 74 68 61 74 20 |nformati|on that |
|000008c0| 77 69 6c 6c 20 68 65 6c | 70 20 79 6f 75 20 75 73 |will hel|p you us|
|000008d0| 65 20 4e 61 70 6b 69 6e | 20 43 61 6c 63 20 74 6f |e Napkin| Calc to|
|000008e0| 20 69 74 d5 73 20 66 75 | 6c 6c 65 73 74 2e 20 54 | it.s fu|llest. T|
|000008f0| 68 69 73 20 70 72 6f 67 | 72 61 6d 20 70 72 6f 76 |his prog|ram prov|
|00000900| 69 64 65 73 20 6d 61 6e | 79 20 66 65 61 74 75 72 |ides man|y featur|
|00000910| 65 73 20 61 6e 64 20 61 | 20 66 65 77 20 d2 68 69 |es and a| few .hi|
|00000920| 64 64 65 6e d3 20 28 6f | 72 20 6c 65 73 73 20 6f |dden. (o|r less o|
|00000930| 62 76 69 6f 75 73 29 ca | 67 6f 6f 64 69 65 73 20 |bvious).|goodies |
|00000940| 77 68 69 63 68 20 79 6f | 75 20 6d 69 67 68 74 20 |which yo|u might |
|00000950| 6e 6f 74 20 62 65 20 61 | 62 6c 65 20 74 6f 20 66 |not be a|ble to f|
|00000960| 69 6e 64 20 77 69 74 68 | 6f 75 74 20 72 65 61 64 |ind with|out read|
|00000970| 69 6e 67 20 61 62 6f 75 | 74 20 74 68 65 6d 2e 0d |ing abou|t them..|
|00000980| 0d 0d 45 4e 54 45 52 49 | 4e 47 20 44 41 54 41 0d |..ENTERI|NG DATA.|
|00000990| 57 68 65 6e 20 79 6f 75 | 20 68 61 76 65 20 63 72 |When you| have cr|
|000009a0| 65 61 74 65 64 20 61 20 | 6e 65 77 20 73 68 65 65 |eated a |new shee|
|000009b0| 74 20 77 69 74 68 20 74 | 68 65 20 4e 65 77 20 62 |t with t|he New b|
|000009c0| 75 74 74 6f 6e 2c 20 79 | 6f 75 20 63 61 6e 20 65 |utton, y|ou can e|
|000009d0| 6e 74 65 72 20 64 61 74 | 61 20 69 6e 20 61 6e 79 |nter dat|a in any|
|000009e0| 20 63 65 6c 6c 20 63 75 | 72 72 65 6e 74 6c 79 20 | cell cu|rrently |
|000009f0| 76 69 73 69 62 6c 65 20 | 73 69 6d 70 6c 79 20 62 |visible |simply b|
|00000a00| 79 20 77 72 69 74 69 6e | 67 20 69 6e 20 69 74 20 |y writin|g in it |
|00000a10| 77 69 74 68 20 79 6f 75 | 72 20 70 65 6e 2e 20 4e |with you|r pen. N|
|00000a20| 6f 20 6e 65 65 64 20 66 | 6f 72 20 73 70 65 63 69 |o need f|or speci|
|00000a30| 61 6c 20 65 64 69 74 6f | 72 73 2c 20 6a 75 73 74 |al edito|rs, just|
|00000a40| 20 77 72 69 74 65 20 61 | 6e 64 20 73 65 65 20 74 | write a|nd see t|
|00000a50| 68 65 20 72 65 73 75 6c | 74 20 70 6c 61 63 65 20 |he resul|t place |
|00000a60| 69 74 73 65 6c 66 20 69 | 6e 20 74 68 65 20 63 6f |itself i|n the co|
|00000a70| 72 72 65 63 74 20 63 65 | 6c 6c 2e 20 54 68 65 20 |rrect ce|ll. The |
|00000a80| 64 61 74 61 20 69 6e 20 | 74 68 65 20 63 65 6c 6c |data in |the cell|
|00000a90| 20 63 61 6e 20 62 65 20 | 65 64 69 74 65 64 20 75 | can be |edited u|
|00000aa0| 73 69 6e 67 20 74 68 65 | 20 73 61 6d 65 20 6d 65 |sing the| same me|
|00000ab0| 74 68 6f 64 73 20 79 6f | 75 d5 72 65 20 75 73 65 |thods yo|u.re use|
|00000ac0| 64 20 74 6f 20 75 73 69 | 6e 67 20 69 6e 20 6f 74 |d to usi|ng in ot|
|00000ad0| 68 65 72 20 61 70 70 6c | 69 63 61 74 69 6f 6e 73 |her appl|ications|
|00000ae0| 20 6f 6e 20 79 6f 75 72 | 20 64 65 76 69 63 65 2e | on your| device.|
|00000af0| 20 54 68 69 73 20 6d 65 | 61 6e 20 74 68 61 74 20 | This me|an that |
|00000b00| 79 6f 75 20 63 61 6e 20 | 73 63 72 75 62 2c 20 69 |you can |scrub, i|
|00000b10| 6e 73 65 72 74 20 73 70 | 61 63 65 73 2c 20 64 6f |nsert sp|aces, do|
|00000b20| 75 62 6c 65 2d 74 61 70 | 2c 20 65 74 63 2e 0d 0d |uble-tap|, etc...|
|00000b30| 4f 6e 65 20 6f 66 20 74 | 68 65 20 62 75 74 74 6f |One of t|he butto|
|00000b40| 6e 73 20 79 6f 75 20 6d | 69 67 68 74 20 66 69 6e |ns you m|ight fin|
|00000b50| 64 20 75 73 65 66 75 6c | 20 69 73 20 74 68 65 20 |d useful| is the |
|00000b60| d2 41 d3 20 62 75 74 74 | 6f 6e 2e 20 54 68 69 73 |.A. butt|on. This|
|00000b70| 20 62 75 74 74 6f 6e 20 | 69 6e 64 69 63 61 74 65 | button |indicate|
|00000b80| 73 20 74 68 61 74 20 79 | 6f 75 20 63 61 6e 20 65 |s that y|ou can e|
|00000b90| 6e 74 65 72 20 61 6e 79 | 74 68 69 6e 67 20 69 6e |nter any|thing in|
|00000ba0| 20 74 68 65 20 63 65 6c | 6c 73 20 79 6f 75 20 73 | the cel|ls you s|
|00000bb0| 65 65 2e 20 49 66 20 79 | 6f 75 20 74 61 70 20 6f |ee. If y|ou tap o|
|00000bc0| 6e 20 74 68 65 20 62 75 | 74 74 6f 6e 2c 20 69 74 |n the bu|tton, it|
|00000bd0| d5 6c 6c 20 63 68 61 6e | 67 65 20 69 74 73 65 6c |.ll chan|ge itsel|
|00000be0| 66 20 74 6f 20 73 68 6f | 77 20 61 20 d2 33 d3 2c |f to sho|w a .3.,|
|00000bf0| 20 74 68 69 73 20 6d 65 | 61 6e 73 20 74 68 61 74 | this me|ans that|
|00000c00| 20 79 6f 75 20 63 61 6e | 20 6e 6f 77 20 4f 4e 4c | you can| now ONL|
|00000c10| 59 20 65 6e 74 65 72 20 | 6e 75 6d 62 65 72 73 20 |Y enter |numbers |
|00000c20| 69 6e 20 74 68 65 20 63 | 65 6c 6c 73 2e 20 54 68 |in the c|ells. Th|
|00000c30| 69 73 20 69 73 20 70 72 | 61 63 74 69 63 61 6c 20 |is is pr|actical |
|00000c40| 69 66 20 79 6f 75 20 64 | 6f 20 61 20 6c 6f 74 20 |if you d|o a lot |
|00000c50| 6f 66 20 6e 75 6d 65 72 | 69 63 61 6c 20 69 6e 70 |of numer|ical inp|
|00000c60| 75 74 2c 20 73 69 6e 63 | 65 20 6e 75 6d 62 65 72 |ut, sinc|e number|
|00000c70| 20 69 6e 74 65 72 70 72 | 65 74 61 74 69 6f 6e 20 | interpr|etation |
|00000c80| 69 73 20 6f 66 74 65 6e | 20 6d 6f 72 65 20 61 63 |is often| more ac|
|00000c90| 63 75 72 61 74 65 20 69 | 66 20 77 65 20 74 65 6c |curate i|f we tel|
|00000ca0| 6c 20 74 68 65 20 70 72 | 6f 67 72 61 6d 20 77 68 |l the pr|ogram wh|
|00000cb0| 61 74 20 74 6f 20 6c 6f | 6f 6b 20 66 6f 72 2e 20 |at to lo|ok for. |
|00000cc0| 54 6f 20 72 65 74 75 72 | 6e 20 74 6f 20 6e 6f 72 |To retur|n to nor|
|00000cd0| 6d 61 6c 20 64 61 74 61 | 20 65 6e 74 72 79 2c 20 |mal data| entry, |
|00000ce0| 74 61 70 20 6f 6e 20 74 | 68 65 20 d2 33 d3 20 62 |tap on t|he .3. b|
|00000cf0| 75 74 74 6f 6e 2c 20 74 | 68 65 20 d2 41 d3 20 77 |utton, t|he .A. w|
|00000d00| 69 6c 6c 20 72 65 61 70 | 70 65 61 72 2c 20 6d 65 |ill reap|pear, me|
|00000d10| 61 6e 69 6e 67 20 74 68 | 61 74 20 74 68 69 6e 67 |aning th|at thing|
|00000d20| 73 20 61 72 65 20 62 61 | 63 6b 20 74 6f 20 6e 6f |s are ba|ck to no|
|00000d30| 72 6d 61 6c 2e 0d 0d 54 | 49 50 3a ca 52 65 63 6f |rmal...T|IP:.Reco|
|00000d40| 67 6e 69 74 69 6f 6e 20 | 77 6f 72 6b 73 20 61 20 |gnition |works a |
|00000d50| 6c 6f 74 20 62 65 74 74 | 65 72 20 69 66 20 79 6f |lot bett|er if yo|
|00000d60| 75 20 74 61 6b 65 20 79 | 6f 75 72 20 74 69 6d 65 |u take y|our time|
|00000d70| 20 77 68 65 6e 20 65 6e | 74 65 72 69 6e 67 20 64 | when en|tering d|
|00000d80| 61 74 61 2e 20 41 6c 74 | 68 6f 75 67 68 20 69 74 |ata. Alt|hough it|
|00000d90| 20 69 73 20 70 6f 73 73 | 69 62 6c 65 20 74 6f 20 | is poss|ible to |
|00000da0| 77 72 69 74 65 20 71 75 | 69 63 6b 6c 79 20 69 6e |write qu|ickly in|
|00000db0| 20 6d 61 6e 79 20 64 69 | 66 66 65 72 65 6e 74 20 | many di|fferent |
|00000dc0| 63 65 6c 6c 73 2c 20 77 | 65 20 68 61 76 65 20 6e |cells, w|e have n|
|00000dd0| 6f 74 69 63 65 64 20 74 | 68 61 74 20 74 68 65 20 |oticed t|hat the |
|00000de0| 62 65 73 74 20 72 65 73 | 75 6c 74 73 20 61 72 65 |best res|ults are|
|00000df0| 20 6f 62 74 61 69 6e 65 | 64 20 69 66 20 79 6f 75 | obtaine|d if you|
|00000e00| 20 72 65 6c 61 78 20 61 | 6e 64 20 6e 6f 74 20 72 | relax a|nd not r|
|00000e10| 75 73 68 20 74 68 69 6e | 67 73 2e 0d 0d 0d 43 48 |ush thin|gs....CH|
|00000e20| 41 4e 47 49 4e 47 20 41 | 20 53 48 45 45 54 d5 53 |ANGING A| SHEET.S|
|00000e30| 20 4e 41 4d 45 0d 41 73 | 20 79 6f 75 d5 76 65 20 | NAME.As| you.ve |
|00000e40| 70 72 6f 62 61 62 6c 79 | 20 6e 6f 74 69 63 65 64 |probably| noticed|
|00000e50| 2c 20 79 6f 75 72 20 73 | 68 65 65 74 20 69 73 20 |, your s|heet is |
|00000e60| 63 61 6c 6c 65 64 20 d2 | 4e 65 77 73 68 65 65 74 |called .|Newsheet|
|00000e70| d3 2e 20 4e 6f 74 20 76 | 65 72 79 20 64 65 73 63 |.. Not v|ery desc|
|00000e80| 72 69 70 74 69 76 65 2e | 20 59 6f 75 d5 64 20 6c |riptive.| You.d l|
|00000e90| 69 6b 65 20 74 6f 20 63 | 68 61 6e 67 65 20 74 68 |ike to c|hange th|
|00000ea0| 69 73 20 6e 61 6d 65 20 | 74 6f 20 73 6f 6d 65 74 |is name |to somet|
|00000eb0| 68 69 6e 67 20 6d 6f 72 | 65 20 73 75 69 74 69 6e |hing mor|e suitin|
|00000ec0| 67 3f 20 45 61 73 79 21 | ca 44 6f 75 62 6c 65 2d |g? Easy!|.Double-|
|00000ed0| 74 61 70 20 6f 6e 20 74 | 68 65 20 74 69 74 6c 65 |tap on t|he title|
|00000ee0| 20 69 74 73 65 6c 66 2c | 20 79 6f 75 d5 6c 6c 20 | itself,| you.ll |
|00000ef0| 73 65 65 20 74 68 65 20 | 67 72 69 64 20 64 69 73 |see the |grid dis|
|00000f00| 61 70 70 65 61 72 20 61 | 6e 64 20 62 65 20 72 65 |appear a|nd be re|
|00000f10| 70 6c 61 63 65 64 20 62 | 79 20 61 6e 20 61 72 65 |placed b|y an are|
|00000f20| 61 20 69 6e 20 77 68 69 | 63 68 20 79 6f 75 20 63 |a in whi|ch you c|
|00000f30| 61 6e 20 63 68 61 6e 67 | 65 20 74 68 65 20 73 68 |an chang|e the sh|
|00000f40| 65 65 74 d5 73 20 6e 61 | 6d 65 2c 20 61 73 20 77 |eet.s na|me, as w|
|00000f50| 65 6c 6c 20 61 73 20 65 | 6e 74 65 72 20 61 20 66 |ell as e|nter a f|
|00000f60| 65 77 20 63 6f 6d 6d 65 | 6e 74 73 2e 20 57 68 65 |ew comme|nts. Whe|
|00000f70| 6e 20 79 6f 75 d5 72 65 | 20 66 69 6e 69 73 68 65 |n you.re| finishe|
|00000f80| 64 2c 20 64 6f 75 62 6c | 65 2d 74 61 70 20 69 6e |d, doubl|e-tap in|
|00000f90| 20 68 65 20 73 68 65 65 | 74 d5 73 20 68 65 61 64 | he shee|t.s head|
|00000fa0| 65 72 20 6f 6e 63 65 20 | 61 67 61 69 6e 20 74 6f |er once |again to|
|00000fb0| 20 73 65 65 20 74 68 65 | 20 63 65 6c 6c 73 20 72 | see the| cells r|
|00000fc0| 65 61 70 70 65 61 72 2e | 0d 0d 0d 53 45 45 49 4e |eappear.|...SEEIN|
|00000fd0| 47 20 4d 4f 52 45 20 44 | 41 54 41 20 2f 20 4e 41 |G MORE D|ATA / NA|
|00000fe0| 56 49 47 41 54 49 4e 47 | 0d 59 6f 75 72 20 6d 61 |VIGATING|.Your ma|
|00000ff0| 78 69 6d 75 6d 20 73 70 | 61 63 65 20 63 75 72 72 |ximum sp|ace curr|
|00001000| 65 6e 74 6c 79 20 61 76 | 61 69 6c 61 62 6c 65 20 |ently av|ailable |
|00001010| 69 73 20 32 36 20 63 6f | 6c 75 6d 6e 73 20 62 79 |is 26 co|lumns by|
|00001020| 20 34 30 20 72 6f 77 73 | 2e 20 42 75 74 20 79 6f | 40 rows|. But yo|
|00001030| 75 20 63 61 6e 20 6e 6f | 74 20 73 65 65 20 74 68 |u can no|t see th|
|00001040| 65 6d 20 61 6c 6c 20 61 | 74 20 6f 6e 63 65 20 6f |em all a|t once o|
|00001050| 6e 20 79 6f 75 72 20 73 | 63 72 65 65 6e 2e 20 54 |n your s|creen. T|
|00001060| 68 65 72 65 66 6f 72 65 | 2c 20 79 6f 75 20 6d 69 |herefore|, you mi|
|00001070| 67 68 74 20 77 61 6e 74 | 20 74 6f 20 6d 6f 76 65 |ght want| to move|
|00001080| 20 61 72 6f 75 6e 64 20 | 79 6f 75 72 20 73 68 65 | around |your she|
|00001090| 65 74 20 74 6f 20 73 65 | 65 20 74 68 65 20 72 65 |et to se|e the re|
|000010a0| 73 74 20 6f 66 20 74 68 | 65 20 69 6e 66 6f 72 6d |st of th|e inform|
|000010b0| 61 74 69 6f 6e 20 79 6f | 75 20 65 6e 74 65 72 65 |ation yo|u entere|
|000010c0| 64 2e 0d 0d 54 68 65 20 | 73 69 6d 70 6c 65 73 74 |d...The |simplest|
|000010d0| 20 6d 65 74 68 6f 64 20 | 69 73 20 74 6f 20 74 61 | method |is to ta|
|000010e0| 70 20 69 6e 20 6f 6e 65 | 20 6f 66 20 74 68 65 20 |p in one| of the |
|000010f0| 66 6f 75 72 20 73 63 72 | 6f 6c 6c 20 61 72 72 6f |four scr|oll arro|
|00001100| 77 73 20 28 75 70 2c 20 | 64 6f 77 6e 2c 20 6c 65 |ws (up, |down, le|
|00001110| 66 74 20 61 6e 64 20 72 | 69 67 68 74 29 2e 20 54 |ft and r|ight). T|
|00001120| 68 65 73 65 20 61 72 72 | 6f 77 73 20 77 69 6c 6c |hese arr|ows will|
|00001130| 20 73 63 72 6f 6c 6c 20 | 79 6f 75 72 20 73 68 65 | scroll |your she|
|00001140| 65 74 20 62 79 20 61 20 | 70 72 65 64 65 74 65 72 |et by a |predeter|
|00001150| 6d 69 6e 65 64 20 6e 75 | 6d 62 65 72 20 6f 66 20 |mined nu|mber of |
|00001160| 63 65 6c 6c 73 2e 0d 0d | 59 6f 75 20 63 61 6e 20 |cells...|You can |
|00001170| 61 6c 73 6f 20 6d 6f 76 | 65 20 79 6f 75 72 20 73 |also mov|e your s|
|00001180| 68 65 65 74 20 61 72 6f | 75 6e 64 20 62 79 20 74 |heet aro|und by t|
|00001190| 61 70 70 69 6e 67 20 69 | 6e 20 74 68 65 20 74 69 |apping i|n the ti|
|000011a0| 74 6c 65 20 6f 66 20 74 | 68 65 20 73 68 65 65 74 |tle of t|he sheet|
|000011b0| 20 61 6e 64 20 64 72 61 | 67 67 69 6e 67 20 69 74 | and dra|gging it|
|000011c0| 20 61 72 6f 75 6e 64 20 | 6f 6e 20 74 68 65 20 73 | around |on the s|
|000011d0| 63 72 65 65 6e 2e 20 4f | 6e 63 65 20 61 20 73 68 |creen. O|nce a sh|
|000011e0| 65 65 74 20 69 73 20 77 | 68 65 72 65 20 79 6f 75 |eet is w|here you|
|000011f0| 20 77 61 6e 74 20 69 74 | 20 74 6f 20 62 65 2c 20 | want it| to be, |
|00001200| 79 6f 75 20 63 61 6e 20 | 63 68 61 6e 67 65 20 69 |you can |change i|
|00001210| 74 d5 73 20 73 69 7a 65 | 20 62 79 20 74 61 70 70 |t.s size| by tapp|
|00001220| 69 6e 67 20 69 6e 20 69 | 74 d5 73 20 6c 6f 77 65 |ing in i|t.s lowe|
|00001230| 72 20 72 69 67 68 74 20 | 63 6f 72 6e 65 72 20 28 |r right |corner (|
|00001240| 6f 6e 20 74 68 65 20 6c | 69 74 74 6c 65 20 62 6c |on the l|ittle bl|
|00001250| 61 63 6b 20 62 6f 78 29 | 2e 20 54 68 69 73 20 77 |ack box)|. This w|
|00001260| 69 6c 6c 20 6c 65 74 20 | 79 6f 75 20 6d 6f 76 65 |ill let |you move|
|00001270| 20 74 68 65 20 63 6f 72 | 6e 65 72 20 6f 66 20 74 | the cor|ner of t|
|00001280| 68 65 20 73 68 65 65 74 | 20 61 72 6f 75 6e 64 20 |he sheet| around |
|00001290| 61 6e 64 20 6d 61 6b 65 | 20 79 6f 75 72 20 64 69 |and make| your di|
|000012a0| 73 70 6c 61 79 20 61 72 | 65 61 20 61 73 20 62 69 |splay ar|ea as bi|
|000012b0| 67 2c 20 6f 72 20 61 73 | 20 73 6d 61 6c 6c 20 61 |g, or as| small a|
|000012c0| 73 20 79 6f 75 20 77 69 | 73 68 20 69 74 20 74 6f |s you wi|sh it to|
|000012d0| 20 62 65 2e 0d 0d 43 65 | 6c 6c 73 20 63 61 6e 20 | be...Ce|lls can |
|000012e0| 62 65 20 72 65 73 69 7a | 65 64 2e 20 49 66 20 79 |be resiz|ed. If y|
|000012f0| 6f 75 20 74 61 70 20 6f | 6e 20 61 20 6c 69 6e 65 |ou tap o|n a line|
|00001300| 20 6f 72 20 63 6f 6c 75 | 6d 6e 2c 20 74 68 65 79 | or colu|mn, they|
|00001310| 20 63 61 6e 20 62 65 20 | 64 72 61 67 67 65 64 20 | can be |dragged |
|00001320| 61 72 6f 75 6e 64 20 73 | 6f 20 79 6f 75 20 63 61 |around s|o you ca|
|00001330| 6e 20 68 61 76 65 20 62 | 69 67 67 65 72 20 28 6f |n have b|igger (o|
|00001340| 72 20 73 6d 61 6c 6c 65 | 72 29 20 63 6f 6c 75 6d |r smalle|r) colum|
|00001350| 6e 73 20 61 6e 64 20 6c | 69 6e 65 73 2e 20 54 68 |ns and l|ines. Th|
|00001360| 69 73 20 6c 65 74 73 20 | 79 6f 75 20 64 69 73 70 |is lets |you disp|
|00001370| 6c 61 79 20 6d 6f 72 65 | 20 64 61 74 61 20 6f 6e |lay more| data on|
|00001380| 20 73 63 72 65 65 6e 20 | 61 74 20 61 20 74 69 6d | screen |at a tim|
|00001390| 65 2c 20 6f 72 20 68 61 | 76 65 20 6d 6f 72 65 20 |e, or ha|ve more |
|000013a0| 73 70 61 63 65 20 62 65 | 74 77 65 65 6e 20 77 68 |space be|tween wh|
|000013b0| 61 74 20 79 6f 75 20 65 | 6e 74 65 72 65 64 2e 20 |at you e|ntered. |
|000013c0| 52 65 73 69 7a 69 6e 67 | 20 63 65 6c 6c 73 20 61 |Resizing| cells a|
|000013d0| 6c 73 6f 20 68 65 6c 70 | 73 20 79 6f 75 20 70 72 |lso help|s you pr|
|000013e0| 65 70 61 72 65 20 61 20 | 70 72 65 73 65 6e 74 61 |epare a |presenta|
|000013f0| 62 6c 65 20 73 70 72 65 | 61 64 73 68 65 65 74 20 |ble spre|adsheet |
|00001400| 28 63 65 6c 6c 73 20 73 | 69 7a 65 73 20 61 72 65 |(cells s|izes are|
|00001410| 20 74 61 6b 65 6e 20 69 | 6e 74 6f 20 61 63 63 6f | taken i|nto acco|
|00001420| 75 6e 74 20 77 68 65 6e | 20 70 72 69 6e 74 69 6e |unt when| printin|
|00001430| 67 2f 66 61 78 69 6e 67 | 29 2e 20 52 65 73 69 7a |g/faxing|). Resiz|
|00001440| 69 6e 67 20 63 65 6c 6c | 73 20 63 61 6e 20 62 65 |ing cell|s can be|
|00001450| 20 75 6e 64 6f 6e 65 20 | 75 73 69 6e 67 20 74 68 | undone |using th|
|00001460| 65 20 55 6e 64 6f 20 62 | 75 74 74 6f 6e 2e 0d 0d |e Undo b|utton...|
|00001470| 54 68 65 20 6c 61 73 74 | 2c 20 61 6e 64 20 70 72 |The last|, and pr|
|00001480| 6f 62 61 62 6c 79 20 74 | 68 65 20 6e 65 61 74 65 |obably t|he neate|
|00001490| 73 74 20 6f 70 74 69 6f | 6e 20 69 73 20 74 6f 20 |st optio|n is to |
|000014a0| 74 61 70 20 6f 6e 20 61 | 20 73 68 65 65 74 d5 73 |tap on a| sheet.s|
|000014b0| 20 4d 61 70 20 62 75 74 | 74 6f 6e 2e 20 54 68 61 | Map but|ton. Tha|
|000014c0| 74 d5 73 20 74 68 65 20 | 62 75 74 74 6f 6e 20 73 |t.s the |button s|
|000014d0| 69 74 75 61 74 65 64 20 | 69 6e 20 74 68 65 20 75 |ituated |in the u|
|000014e0| 70 70 65 72 20 72 69 67 | 68 74 20 63 6f 72 6e 65 |pper rig|ht corne|
|000014f0| 72 20 6f 66 20 61 20 73 | 68 65 65 74 2c 20 6a 75 |r of a s|heet, ju|
|00001500| 73 74 20 6e 65 78 74 20 | 74 6f 20 74 68 65 20 63 |st next |to the c|
|00001510| 6c 6f 73 65 20 62 6f 78 | 2e 20 49 66 20 79 6f 75 |lose box|. If you|
|00001520| 20 68 6f 6c 64 20 74 68 | 65 20 70 65 6e 20 64 6f | hold th|e pen do|
|00001530| 77 6e 20 61 20 6d 6f 6d | 65 6e 74 2c 20 79 6f 75 |wn a mom|ent, you|
|00001540| d5 6c 6c 20 73 65 65 20 | 61 20 67 72 61 70 68 69 |.ll see |a graphi|
|00001550| 63 61 6c 20 72 65 70 72 | 65 73 65 6e 74 61 74 69 |cal repr|esentati|
|00001560| 6f 6e 20 6f 66 20 79 6f | 75 72 20 74 6f 74 61 6c |on of yo|ur total|
|00001570| 20 61 76 61 69 6c 61 62 | 6c 65 20 73 70 61 63 65 | availab|le space|
|00001580| 20 28 69 65 3a ca 32 36 | 20 63 6f 6c 75 6d 6e 73 | (ie:.26| columns|
|00001590| 20 62 79 20 34 30 20 72 | 6f 77 73 29 2e 20 59 6f | by 40 r|ows). Yo|
|000015a0| 75 72 20 63 75 72 72 65 | 6e 74 20 70 6f 73 69 74 |ur curre|nt posit|
|000015b0| 69 6f 6e 20 77 69 6c 6c | 20 62 65 20 72 65 70 72 |ion will| be repr|
|000015c0| 65 73 65 6e 74 65 64 20 | 62 79 20 61 20 6c 69 74 |esented |by a lit|
|000015d0| 74 6c 65 20 62 6c 61 63 | 6b 20 72 65 63 74 61 6e |tle blac|k rectan|
|000015e0| 67 6c 65 20 77 68 69 63 | 68 20 79 6f 75 20 63 61 |gle whic|h you ca|
|000015f0| 6e 20 6d 6f 76 65 20 61 | 72 6f 75 6e 64 20 6d 79 |n move a|round my|
|00001600| 20 6d 6f 76 69 6e 67 20 | 79 6f 75 72 20 70 65 6e | moving |your pen|
|00001610| 2e 20 49 66 20 79 6f 75 | 20 6c 65 74 20 74 68 65 |. If you| let the|
|00001620| 20 70 65 6e 20 67 6f 2c | 20 79 6f 75 72 20 73 68 | pen go,| your sh|
|00001630| 65 65 74 20 77 69 6c 6c | 20 69 6d 6d 65 64 69 61 |eet will| immedia|
|00001640| 74 65 6c 79 20 6d 6f 76 | 65 20 74 6f 20 74 68 65 |tely mov|e to the|
|00001650| 20 61 72 65 61 20 77 68 | 65 72 65 20 74 68 65 20 | area wh|ere the |
|00001660| 62 6f 78 20 63 6f 75 6c | 64 20 62 65 20 73 65 65 |box coul|d be see|
|00001670| 6e 2e 20 54 6f 20 68 65 | 6c 70 20 79 6f 75 20 66 |n. To he|lp you f|
|00001680| 69 6e 64 20 79 6f 75 72 | 20 77 61 79 20 61 72 6f |ind your| way aro|
|00001690| 75 6e 64 20 74 68 65 20 | 6d 61 70 2c 20 6c 69 74 |und the |map, lit|
|000016a0| 74 6c 65 20 6c 69 6e 65 | 73 20 69 6e 64 69 63 61 |tle line|s indica|
|000016b0| 74 65 20 77 68 65 72 65 | 20 79 6f 75 d5 76 65 20 |te where| you.ve |
|000016c0| 65 6e 74 65 72 65 64 20 | 64 61 74 61 2e 20 49 66 |entered |data. If|
|000016d0| 20 79 6f 75 20 62 72 69 | 6e 67 20 74 68 65 20 62 | you bri|ng the b|
|000016e0| 6c 61 63 6b 20 6d 61 72 | 6b 65 72 20 6f 76 65 72 |lack mar|ker over|
|000016f0| 20 73 6f 6d 65 20 6f 66 | 20 74 68 6f 73 65 20 6c | some of| those l|
|00001700| 69 6e 65 73 20 61 6e 64 | 20 6c 69 66 74 20 75 70 |ines and| lift up|
|00001710| 20 74 68 65 20 70 65 6e | 2c 20 79 6f 75 d5 6c 6c | the pen|, you.ll|
|00001720| 20 73 65 65 20 74 68 65 | 20 64 61 74 61 20 79 6f | see the| data yo|
|00001730| 75 20 65 6e 74 65 72 65 | 64 20 74 68 65 72 65 2e |u entere|d there.|
|00001740| 0d 0d 54 49 50 3a ca 59 | 6f 75 20 63 61 6e 20 71 |..TIP:.Y|ou can q|
|00001750| 75 69 63 6b 6c 79 20 67 | 6f 20 62 61 63 6b 20 74 |uickly g|o back t|
|00001760| 6f 20 74 68 65 20 66 69 | 72 73 74 20 63 65 6c 6c |o the fi|rst cell|
|00001770| 20 69 6e 20 79 6f 75 72 | 20 73 68 65 65 74 20 62 | in your| sheet b|
|00001780| 79 20 64 6f 75 62 6c 65 | 2d 74 61 70 70 69 6e 67 |y double|-tapping|
|00001790| 20 6f 6e 20 74 68 65 20 | 4d 61 70 20 62 75 74 74 | on the |Map butt|
|000017a0| 6f 6e 2e 0d 0d 0d 53 45 | 45 49 4e 47 20 41 20 53 |on....SE|EING A S|
|000017b0| 48 45 45 54 0d 53 6f 20 | 79 6f 75 20 63 72 65 61 |HEET.So |you crea|
|000017c0| 74 65 64 20 61 20 73 68 | 65 65 74 2c 20 71 75 69 |ted a sh|eet, qui|
|000017d0| 74 20 61 6e 64 20 77 65 | 6e 74 20 62 61 63 6b 20 |t and we|nt back |
|000017e0| 69 6e 2c 20 61 6e 64 20 | 79 6f 75 20 77 61 6e 74 |in, and |you want|
|000017f0| 20 74 6f 20 73 65 65 20 | 79 6f 75 72 20 73 68 65 | to see |your she|
|00001800| 65 74 2e 20 54 68 65 20 | 73 63 72 65 65 6e 20 69 |et. The |screen i|
|00001810| 73 20 62 6c 61 6e 6b 2c | 20 77 68 65 72 65 20 68 |s blank,| where h|
|00001820| 61 73 20 69 74 20 67 6f | 6e 65 3f ca 49 74 d5 73 |as it go|ne?.It.s|
|00001830| 20 73 74 69 6c 6c 20 74 | 68 65 72 65 2c 20 62 75 | still t|here, bu|
|00001840| 74 20 79 6f 75 20 6d 75 | 73 74 20 74 65 6c 6c 20 |t you mu|st tell |
|00001850| 4e 61 70 6b 69 6e 20 43 | 61 6c 63 20 79 6f 75 20 |Napkin C|alc you |
|00001860| 77 61 6e 74 20 74 6f 20 | 73 65 65 20 69 74 2e 20 |want to |see it. |
|00001870| 54 6f 20 64 6f 20 74 68 | 69 73 2c 20 74 61 70 20 |To do th|is, tap |
|00001880| 6f 6e 20 74 68 65 20 4f | 76 65 72 76 69 65 77 20 |on the O|verview |
|00001890| 62 75 74 74 6f 6e 20 28 | 61 6c 73 6f 20 6b 6e 6f |button (|also kno|
|000018a0| 77 6e 20 61 73 20 74 68 | 65 20 62 65 6c 6c 79 20 |wn as th|e belly |
|000018b0| 62 75 74 74 6f 6e 2c 20 | 61 74 20 74 68 65 20 62 |button, |at the b|
|000018c0| 6f 74 74 6f 6d 20 6f 66 | 20 79 6f 75 72 20 73 63 |ottom of| your sc|
|000018d0| 72 65 65 6e 29 2e 20 54 | 68 69 73 20 77 69 6c 6c |reen). T|his will|
|000018e0| 20 62 72 69 6e 67 20 75 | 70 20 61 20 77 69 6e 64 | bring u|p a wind|
|000018f0| 6f 77 20 69 6e 20 77 68 | 69 63 68 20 79 6f 75 20 |ow in wh|ich you |
|00001900| 73 65 65 20 74 68 65 20 | 6e 61 6d 65 73 20 6f 66 |see the |names of|
|00001910| 20 61 6c 6c 20 74 68 65 | 20 73 68 65 65 74 73 20 | all the| sheets |
|00001920| 79 6f 75 20 63 72 65 61 | 74 65 64 2e 20 54 6f 20 |you crea|ted. To |
|00001930| 68 61 76 65 20 61 20 73 | 68 65 65 74 20 61 70 70 |have a s|heet app|
|00001940| 65 61 72 2c 20 6a 75 73 | 74 20 74 61 70 20 6f 6e |ear, jus|t tap on|
|00001950| 20 69 74 d5 73 20 6e 61 | 6d 65 2e 20 57 68 65 6e | it.s na|me. When|
|00001960| 20 79 6f 75 d5 72 65 20 | 66 69 6e 69 73 68 65 64 | you.re |finished|
|00001970| 20 77 69 74 68 20 74 68 | 69 73 20 6c 69 73 74 20 | with th|is list |
|00001980| 6f 66 20 73 68 65 65 74 | 73 2c 20 79 6f 75 20 63 |of sheet|s, you c|
|00001990| 61 6e 20 63 6c 6f 73 65 | 20 69 74 20 62 79 20 74 |an close| it by t|
|000019a0| 61 70 70 69 6e 67 20 69 | 6e 20 74 68 65 20 63 6c |apping i|n the cl|
|000019b0| 6f 73 65 20 62 6f 78 20 | 61 74 20 74 68 65 20 75 |ose box |at the u|
|000019c0| 70 70 65 72 20 72 69 67 | 68 74 20 6f 66 20 69 74 |pper rig|ht of it|
|000019d0| d5 73 20 77 69 6e 64 6f | 77 2e 0d 0d 41 20 73 68 |.s windo|w...A sh|
|000019e0| 6f 72 74 20 63 75 74 20 | 69 73 20 74 6f 20 74 61 |ort cut |is to ta|
|000019f0| 70 20 6f 6e 20 74 68 65 | 20 61 70 70 6c 69 63 61 |p on the| applica|
|00001a00| 74 69 6f 6e d5 73 20 74 | 69 74 6c 65 2e 20 54 68 |tion.s t|itle. Th|
|00001a10| 69 73 20 77 69 6c 6c 20 | 62 72 69 6e 67 20 75 70 |is will |bring up|
|00001a20| 20 61 20 6c 69 73 74 20 | 6f 66 20 73 68 65 65 74 | a list |of sheet|
|00001a30| 73 20 66 72 6f 6d 20 77 | 68 69 63 68 20 79 6f 75 |s from w|hich you|
|00001a40| 20 63 61 6e 20 71 75 69 | 63 6b 6c 79 20 73 65 6c | can qui|ckly sel|
|00001a50| 65 63 74 20 74 68 65 20 | 6f 6e 65 20 79 6f 75 d5 |ect the |one you.|
|00001a60| 64 20 6c 69 6b 65 20 74 | 6f 20 73 65 65 2e 0d 0d |d like t|o see...|
|00001a70| 0d 4f 50 54 49 4f 4e 53 | 0d 4f 6e 65 20 6f 66 20 |.OPTIONS|.One of |
|00001a80| 74 68 65 20 62 75 74 74 | 6f 6e 73 20 79 6f 75 20 |the butt|ons you |
|00001a90| 66 69 6e 64 20 61 74 20 | 74 68 65 20 62 6f 74 74 |find at |the bott|
|00001aa0| 6f 6d 20 6f 66 20 79 6f | 75 72 20 73 63 72 65 65 |om of yo|ur scree|
|00001ab0| 6e 20 69 73 20 63 61 6c | 6c 65 64 20 4f 70 74 69 |n is cal|led Opti|
|00001ac0| 6f 6e 73 2e 20 49 66 20 | 79 6f 75 20 74 61 70 20 |ons. If |you tap |
|00001ad0| 69 74 2c 20 79 6f 75 d5 | 6c 6c 20 73 65 65 20 61 |it, you.|ll see a|
|00001ae0| 20 6d 65 6e 75 20 6f 66 | 20 74 68 69 6e 67 73 20 | menu of| things |
|00001af0| 79 6f 75 20 63 61 6e 20 | 64 6f 2e 20 48 65 72 65 |you can |do. Here|
|00001b00| d5 73 20 61 20 62 72 69 | 65 66 20 64 65 73 63 72 |.s a bri|ef descr|
|00001b10| 69 70 74 69 6f 6e 20 6f | 66 20 77 68 61 74 20 74 |iption o|f what t|
|00001b20| 68 65 73 65 20 63 68 6f | 69 63 65 73 20 61 72 65 |hese cho|ices are|
|00001b30| 2e 0d 0d 45 44 49 54 20 | 50 52 45 46 45 52 45 4e |...EDIT |PREFEREN|
|00001b40| 43 45 53 0d 54 68 69 73 | 20 69 73 20 77 68 65 72 |CES.This| is wher|
|00001b50| 65 20 79 6f 75 20 73 65 | 74 20 63 65 72 74 61 69 |e you se|t certai|
|00001b60| 6e 20 64 65 66 61 75 6c | 74 20 76 61 6c 75 65 73 |n defaul|t values|
|00001b70| 20 74 68 61 74 20 77 69 | 6c 6c 20 62 65 20 75 73 | that wi|ll be us|
|00001b80| 65 64 20 74 68 72 6f 75 | 67 68 6f 75 74 20 74 68 |ed throu|ghout th|
|00001b90| 65 20 70 72 6f 67 72 61 | 6d 2e 0d 0d 53 68 6f 77 |e progra|m...Show|
|00001ba0| 20 53 68 65 65 74 20 48 | 65 61 64 65 72 73 3a 20 | Sheet H|eaders: |
|00001bb0| 4d 61 6e 79 20 70 65 6f | 70 6c 65 20 6e 65 65 64 |Many peo|ple need|
|00001bc0| 20 74 6f 20 73 65 65 20 | 77 68 61 74 20 69 73 20 | to see |what is |
|00001bd0| 63 6f 6d 6d 6f 6e 6c 79 | 20 63 61 6c 6c 65 64 20 |commonly| called |
|00001be0| 61 20 d2 68 65 61 64 65 | 72 d3 20 77 68 65 6e 20 |a .heade|r. when |
|00001bf0| 6c 6f 6f 6b 69 6e 67 20 | 61 74 20 61 20 73 68 65 |looking |at a she|
|00001c00| 65 74 2e 20 42 79 20 73 | 65 6c 65 63 74 69 6e 67 |et. By s|electing|
|00001c10| 20 74 68 69 73 20 6f 70 | 74 69 6f 6e 2c 20 74 68 | this op|tion, th|
|00001c20| 65 20 73 68 65 65 74 73 | 20 79 6f 75 20 6f 70 65 |e sheets| you ope|
|00001c30| 6e 20 77 69 6c 6c 20 68 | 61 76 65 20 62 6f 74 68 |n will h|ave both|
|00001c40| 20 68 6f 72 69 7a 6f 6e | 74 61 6c 20 61 6e 64 20 | horizon|tal and |
|00001c50| 76 65 72 74 69 63 61 6c | 20 68 65 61 64 65 72 73 |vertical| headers|
|00001c60| 20 28 69 65 3a 20 63 6f | 6c 75 6d 6e 73 20 66 72 | (ie: co|lumns fr|
|00001c70| 6f 6d 20 41 20 74 6f 20 | 5a 20 61 6e 64 20 72 6f |om A to |Z and ro|
|00001c80| 77 73 20 66 72 6f 6d 20 | 31 20 74 6f 20 34 30 29 |ws from |1 to 40)|
|00001c90| 2e 0d 0d 52 65 6d 65 6d | 62 65 72 20 4f 70 65 6e |...Remem|ber Open|
|00001ca0| 65 64 20 53 68 65 65 74 | 73 3a 20 53 65 6c 65 63 |ed Sheet|s: Selec|
|00001cb0| 74 69 6e 67 20 74 68 69 | 73 20 63 68 65 63 6b 20 |ting thi|s check |
|00001cc0| 62 6f 78 20 6c 65 74 73 | 20 4e 61 70 6b 69 6e 20 |box lets| Napkin |
|00001cd0| 43 61 6c 63 20 72 65 6d | 65 6d 62 65 72 20 77 68 |Calc rem|ember wh|
|00001ce0| 69 63 68 20 73 68 65 65 | 74 73 20 77 65 72 65 20 |ich shee|ts were |
|00001cf0| 6f 70 65 6e 20 74 68 65 | 20 6c 61 73 74 20 74 69 |open the| last ti|
|00001d00| 6d 65 20 79 6f 75 20 65 | 78 69 74 65 64 20 74 68 |me you e|xited th|
|00001d10| 65 20 70 72 6f 67 72 61 | 6d 2e 20 54 68 65 20 6e |e progra|m. The n|
|00001d20| 65 78 74 20 74 69 6d 65 | 20 79 6f 75 20 72 65 65 |ext time| you ree|
|00001d30| 6e 74 65 72 20 4e 61 70 | 6b 69 6e 20 43 61 6c 63 |nter Nap|kin Calc|
|00001d40| 2c 20 74 68 6f 73 65 20 | 73 68 65 65 74 73 20 77 |, those |sheets w|
|00001d50| 69 6c 6c 20 62 65 20 61 | 75 74 6f 6d 61 74 69 63 |ill be a|utomatic|
|00001d60| 61 6c 6c 79 20 6f 70 65 | 6e 65 64 2e 0d 0d 44 6f |ally ope|ned...Do|
|00001d70| 75 62 6c 65 20 54 61 70 | 20 4f 70 65 6e 73 3a ca |uble Tap| Opens:.|
|00001d80| 54 68 69 73 20 63 68 6f | 69 63 65 20 6c 65 74 73 |This cho|ice lets|
|00001d90| 20 79 6f 75 20 64 65 63 | 69 64 65 20 77 68 61 74 | you dec|ide what|
|00001da0| 20 79 6f 75 20 77 61 6e | 74 20 4e 61 70 6b 69 6e | you wan|t Napkin|
|00001db0| 20 43 61 6c 63 20 74 6f | 20 64 6f 20 77 68 65 6e | Calc to| do when|
|00001dc0| 20 79 6f 75 20 74 61 70 | 20 74 77 69 63 65 20 69 | you tap| twice i|
|00001dd0| 6e 20 61 20 63 65 6c 6c | 2e 20 49 66 20 4b 65 79 |n a cell|. If Key|
|00001de0| 62 6f 61 72 64 20 69 73 | 20 73 65 6c 65 63 74 65 |board is| selecte|
|00001df0| 64 2c 20 61 20 64 6f 75 | 62 6c 65 20 74 61 70 20 |d, a dou|ble tap |
|00001e00| 77 69 6c 6c 20 65 69 74 | 68 65 72 20 73 68 6f 77 |will eit|her show|
|00001e10| 20 61 20 63 68 6f 69 63 | 65 20 6f 66 20 77 6f 72 | a choic|e of wor|
|00001e20| 64 73 20 6f 72 20 62 72 | 69 6e 67 20 75 70 20 74 |ds or br|ing up t|
|00001e30| 68 65 20 6b 65 79 62 6f | 61 72 64 20 66 6f 72 20 |he keybo|ard for |
|00001e40| 64 61 74 61 20 65 6e 74 | 72 79 2e 20 50 6c 65 61 |data ent|ry. Plea|
|00001e50| 73 65 20 6e 6f 74 65 20 | 74 68 61 74 20 69 66 20 |se note |that if |
|00001e60| 79 6f 75 20 68 61 76 65 | 20 73 65 74 20 79 6f 75 |you have| set you|
|00001e70| 72 20 64 61 74 61 20 65 | 6e 74 72 79 20 6f 70 74 |r data e|ntry opt|
|00001e80| 69 6f 6e 20 74 6f 20 6e | 75 6d 65 72 69 63 20 76 |ion to n|umeric v|
|00001e90| 61 6c 75 65 73 20 6f 6e | 6c 79 2c 20 74 68 65 20 |alues on|ly, the |
|00001ea0| 6e 75 6d 65 72 69 63 61 | 6c 20 6b 65 79 62 6f 61 |numerica|l keyboa|
|00001eb0| 72 64 20 77 69 6c 6c 20 | 6f 70 65 6e 20 77 68 65 |rd will |open whe|
|00001ec0| 6e 20 79 6f 75 20 64 6f | 75 62 6c 65 20 74 61 70 |n you do|uble tap|
|00001ed0| 2e 0d 0d 53 63 72 6f 6c | 6c 3a ca 59 6f 75 20 63 |...Scrol|l:.You c|
|00001ee0| 61 6e 20 65 6e 74 65 72 | 20 68 6f 72 69 7a 6f 6e |an enter| horizon|
|00001ef0| 74 61 6c 20 61 6e 64 20 | 76 65 72 74 69 63 61 6c |tal and |vertical|
|00001f00| 20 73 63 72 6f 6c 6c 20 | 76 61 6c 75 65 73 2e 20 | scroll |values. |
|00001f10| 54 68 69 73 20 6d 65 61 | 6e 73 20 74 68 61 74 2c |This mea|ns that,|
|00001f20| 20 77 68 65 6e 20 79 6f | 75 20 74 61 70 20 6f 6e | when yo|u tap on|
|00001f30| 20 6f 6e 65 20 6f 66 20 | 74 68 65 20 73 63 72 6f | one of |the scro|
|00001f40| 6c 6c 20 61 72 72 6f 77 | 73 2c 20 74 68 65 20 66 |ll arrow|s, the f|
|00001f50| 72 6f 6e 74 20 6d 6f 73 | 74 20 73 68 65 65 74 20 |ront mos|t sheet |
|00001f60| 77 69 6c 6c 20 73 63 72 | 6f 6c 6c 20 62 79 20 74 |will scr|oll by t|
|00001f70| 68 65 20 6e 75 6d 62 65 | 72 20 79 6f 75 20 65 6e |he numbe|r you en|
|00001f80| 74 65 72 65 64 20 69 6e | 20 74 68 69 73 20 61 72 |tered in| this ar|
|00001f90| 65 61 2e 20 46 6f 72 20 | 65 78 61 6d 70 6c 65 2c |ea. For |example,|
|00001fa0| 20 69 66 20 79 6f 75 20 | 65 6e 74 65 72 20 35 20 | if you |enter 5 |
|00001fb0| 69 6e 20 74 68 65 20 56 | 65 72 74 69 63 61 6c 20 |in the V|ertical |
|00001fc0| 66 69 65 6c 64 20 61 6e | 64 20 74 61 70 20 6f 6e |field an|d tap on|
|00001fd0| 20 74 68 65 20 44 6f 77 | 6e 20 61 72 72 6f 77 2c | the Dow|n arrow,|
|00001fe0| 20 74 68 65 20 73 68 65 | 65 74 20 77 69 6c 6c 20 | the she|et will |
|00001ff0| 73 63 72 6f 6c 6c 20 64 | 6f 77 6e 20 62 79 20 66 |scroll d|own by f|
|00002000| 69 76 65 20 63 65 6c 6c | 73 2e 0d 0d 52 65 6d 6f |ive cell|s...Remo|
|00002010| 76 65 20 45 76 65 72 79 | 74 68 69 6e 67 3a 20 49 |ve Every|thing: I|
|00002020| 66 20 79 6f 75 20 64 65 | 63 69 64 65 20 74 6f 20 |f you de|cide to |
|00002030| 72 65 6d 6f 76 65 20 4e | 61 70 6b 69 6e 20 43 61 |remove N|apkin Ca|
|00002040| 6c 63 20 66 72 6f 6d 20 | 79 6f 75 72 20 64 65 76 |lc from |your dev|
|00002050| 69 63 65 2c 20 79 6f 75 | 20 6d 75 73 74 20 66 69 |ice, you| must fi|
|00002060| 72 73 74 20 75 73 65 20 | 74 68 69 73 20 62 75 74 |rst use |this but|
|00002070| 74 6f 6e 2e 20 49 74 20 | 77 69 6c 6c 20 61 73 6b |ton. It |will ask|
|00002080| 20 66 6f 72 20 63 6f 6e | 66 69 72 6d 61 74 69 6f | for con|firmatio|
|00002090| 6e 20 61 6e 64 20 74 68 | 65 6e 20 72 65 6d 6f 76 |n and th|en remov|
|000020a0| 65 20 61 6c 6c 20 74 68 | 65 20 64 61 74 61 20 74 |e all th|e data t|
|000020b0| 68 61 74 20 77 61 73 20 | 63 72 65 61 74 65 64 20 |hat was |created |
|000020c0| 77 69 74 68 20 4e 61 70 | 6b 69 6e 20 43 61 6c 63 |with Nap|kin Calc|
|000020d0| 2e 20 49 66 20 79 6f 75 | 20 72 65 6d 6f 76 65 20 |. If you| remove |
|000020e0| 4e 61 70 6b 69 6e 20 43 | 61 6c 63 20 77 69 74 68 |Napkin C|alc with|
|000020f0| 6f 75 74 20 75 73 69 6e | 67 20 74 68 69 73 20 62 |out usin|g this b|
|00002100| 75 74 74 6f 6e 2c 20 61 | 6c 6c 20 74 68 65 20 64 |utton, a|ll the d|
|00002110| 61 74 61 20 73 74 6f 72 | 65 64 20 69 6e 20 79 6f |ata stor|ed in yo|
|00002120| 75 72 20 6d 65 6d 6f 72 | 79 20 77 69 6c 6c 20 73 |ur memor|y will s|
|00002130| 74 69 6c 6c 20 62 65 20 | 74 68 65 72 65 2e 20 54 |till be |there. T|
|00002140| 68 69 73 20 69 73 20 6e | 6f 74 20 62 61 64 20 69 |his is n|ot bad i|
|00002150| 6e 20 69 74 73 65 6c 66 | 2c 20 69 74 d5 73 20 6a |n itself|, it.s j|
|00002160| 75 73 74 20 74 68 61 74 | 20 69 74 20 74 61 6b 65 |ust that| it take|
|00002170| 73 20 61 20 62 69 74 20 | 6f 66 20 73 70 61 63 65 |s a bit |of space|
|00002180| 2e 0d 0d 53 45 54 ca 41 | 54 54 52 49 42 55 54 45 |...SET.A|TTRIBUTE|
|00002190| 53 0d 54 68 65 20 77 61 | 79 20 74 68 69 6e 67 73 |S.The wa|y things|
|000021a0| 20 61 70 70 65 61 72 20 | 69 6e 20 79 6f 75 72 20 | appear |in your |
|000021b0| 73 68 65 65 74 20 6d 69 | 67 68 74 20 6e 6f 74 20 |sheet mi|ght not |
|000021c0| 61 6c 77 61 79 73 20 62 | 65 20 74 68 65 20 77 61 |always b|e the wa|
|000021d0| 79 20 79 6f 75 20 77 61 | 6e 74 20 74 68 65 6d 20 |y you wa|nt them |
|000021e0| 74 6f 20 62 65 2e 20 54 | 68 69 73 20 69 73 20 77 |to be. T|his is w|
|000021f0| 68 79 20 77 65 20 68 61 | 76 65 20 74 68 69 73 20 |hy we ha|ve this |
|00002200| 63 6f 6d 6d 61 6e 64 2e | 20 49 74 20 6c 65 74 73 |command.| It lets|
|00002210| 20 79 6f 75 20 64 65 63 | 69 64 65 20 68 6f 77 20 | you dec|ide how |
|00002220| 63 65 72 74 61 69 6e 20 | 63 65 6c 6c 73 20 77 69 |certain |cells wi|
|00002230| 6c 6c 20 6c 6f 6f 6b 2e | 20 4f 6e 63 65 20 79 6f |ll look.| Once yo|
|00002240| 75 d5 76 65 20 73 65 6c | 65 63 74 65 64 20 74 68 |u.ve sel|ected th|
|00002250| 65 20 63 6f 6d 6d 61 6e | 64 2c 20 61 20 64 69 61 |e comman|d, a dia|
|00002260| 6c 6f 67 20 61 70 70 65 | 61 72 73 20 77 69 74 68 |log appe|ars with|
|00002270| 20 61 6c 6c 20 74 68 65 | 20 61 76 61 69 6c 61 62 | all the| availab|
|00002280| 6c 65 20 6f 70 74 69 6f | 6e 73 2e 20 54 68 65 20 |le optio|ns. The |
|00002290| 66 69 72 73 74 20 74 68 | 69 6e 67 20 79 6f 75 20 |first th|ing you |
|000022a0| 73 68 6f 75 6c 64 20 64 | 6f 20 69 73 20 73 65 6c |should d|o is sel|
|000022b0| 65 63 74 20 74 68 65 20 | 63 65 6c 6c 28 73 29 20 |ect the |cell(s) |
|000022c0| 79 6f 75 20 77 69 73 68 | 20 74 6f 20 61 66 66 65 |you wish| to affe|
|000022d0| 63 74 2e 0d 0d 54 6f 20 | 73 65 6c 65 63 74 20 61 |ct...To |select a|
|000022e0| 20 63 65 6c 6c 2c 20 73 | 69 6d 70 6c 79 20 74 61 | cell, s|imply ta|
|000022f0| 70 20 6f 6e 20 69 74 2e | 20 49 66 20 79 6f 75 20 |p on it.| If you |
|00002300| 77 69 73 68 20 74 6f 20 | 73 65 6c 65 63 74 20 61 |wish to |select a|
|00002310| 20 72 61 6e 67 65 20 6f | 66 20 63 65 6c 6c 73 2c | range o|f cells,|
|00002320| 20 74 61 70 20 6f 6e 20 | 74 68 65 20 66 69 72 73 | tap on |the firs|
|00002330| 74 20 63 65 6c 6c 20 79 | 6f 75 d5 64 20 6c 69 6b |t cell y|ou.d lik|
|00002340| 65 20 61 6e 64 20 6d 6f | 76 65 20 79 6f 75 72 20 |e and mo|ve your |
|00002350| 70 65 6e 20 61 63 72 6f | 73 73 20 79 6f 75 72 20 |pen acro|ss your |
|00002360| 73 63 72 65 65 6e 20 75 | 6e 74 69 6c 20 74 68 65 |screen u|ntil the|
|00002370| 20 73 65 6c 65 63 74 69 | 6f 6e 20 62 6f 78 20 73 | selecti|on box s|
|00002380| 75 72 72 6f 75 6e 64 73 | 20 61 6c 6c 20 74 68 65 |urrounds| all the|
|00002390| 20 64 65 73 69 72 65 64 | 20 63 65 6c 6c 73 2e 20 | desired| cells. |
|000023a0| 57 68 65 6e 20 79 6f 75 | 20 6c 65 74 20 74 68 65 |When you| let the|
|000023b0| 20 70 65 6e 20 67 6f 2c | 20 79 6f 75 d5 6c 6c 20 | pen go,| you.ll |
|000023c0| 73 65 65 20 79 6f 75 72 | 20 63 65 6c 6c 20 63 6f |see your| cell co|
|000023d0| 6f 72 64 69 6e 61 74 65 | 20 28 6f 72 20 61 20 63 |ordinate| (or a c|
|000023e0| 6f 6f 72 64 69 6e 61 74 | 65 20 72 61 6e 67 65 2c |oordinat|e range,|
|000023f0| 20 69 66 20 79 6f 75 20 | 73 65 6c 65 63 74 65 64 | if you |selected|
|00002400| 20 6d 61 6e 79 29 20 61 | 70 70 65 61 72 20 6e 65 | many) a|ppear ne|
|00002410| 78 74 20 74 6f 20 d2 53 | 65 6c 65 63 74 65 64 20 |xt to .S|elected |
|00002420| 63 65 6c 6c 28 73 29 d3 | 20 61 74 20 74 68 65 20 |cell(s).| at the |
|00002430| 62 6f 74 74 6f 6d 20 6f | 66 20 74 68 65 20 64 69 |bottom o|f the di|
|00002440| 61 6c 6f 67 2e 0d 0d 4e | 6f 77 20 79 6f 75 20 68 |alog...N|ow you h|
|00002450| 61 76 65 20 74 6f 20 73 | 65 74 20 61 6c 6c 20 74 |ave to s|et all t|
|00002460| 68 65 20 61 74 74 72 69 | 62 75 74 65 73 20 66 6f |he attri|butes fo|
|00002470| 72 20 61 20 63 65 6c 6c | 2e 20 4f 6e 63 65 20 61 |r a cell|. Once a|
|00002480| 6c 6c 20 69 73 20 61 73 | 20 79 6f 75 20 77 69 73 |ll is as| you wis|
|00002490| 68 2c 20 74 61 70 20 6f | 6e 20 74 68 65 20 52 65 |h, tap o|n the Re|
|000024a0| 74 75 72 6e 20 62 75 74 | 74 6f 6e 20 28 74 68 65 |turn but|ton (the|
|000024b0| 20 6f 6e 65 20 61 62 6f | 76 65 20 74 68 65 20 63 | one abo|ve the c|
|000024c0| 6c 6f 73 65 20 62 6f 78 | 29 2c 20 61 6e 64 20 79 |lose box|), and y|
|000024d0| 6f 75 72 20 73 65 6c 65 | 63 74 65 64 20 63 65 6c |our sele|cted cel|
|000024e0| 6c 73 20 77 69 6c 6c 20 | 62 65 20 61 66 66 65 63 |ls will |be affec|
|000024f0| 74 65 64 2e 0d 0d 53 45 | 54 20 46 4f 52 4d 41 54 |ted...SE|T FORMAT|
|00002500| 54 49 4e 47 0d 54 68 69 | 73 20 6f 70 74 69 6f 6e |TING.Thi|s option|
|00002510| 20 77 6f 72 6b 73 20 6c | 69 6b 65 20 74 68 65 20 | works l|ike the |
|00002520| 53 65 74 20 41 74 74 72 | 69 62 75 74 65 73 20 63 |Set Attr|ibutes c|
|00002530| 6f 6d 6d 61 6e 64 20 69 | 6e 20 74 68 61 74 20 79 |ommand i|n that y|
|00002540| 6f 75 20 68 61 76 65 20 | 74 6f 20 73 65 6c 65 63 |ou have |to selec|
|00002550| 74 20 61 20 63 65 6c 6c | 20 28 6f 66 20 72 61 6e |t a cell| (of ran|
|00002560| 67 65 20 6f 66 20 63 65 | 6c 6c 73 29 ca 74 6f 20 |ge of ce|lls).to |
|00002570| 61 66 66 65 63 74 2e 20 | 42 75 74 20 69 6e 73 74 |affect. |But inst|
|00002580| 65 61 64 20 6f 66 20 63 | 68 61 6e 67 69 6e 67 20 |ead of c|hanging |
|00002590| 74 68 65 69 72 20 6c 6f | 6f 6b 2c 20 79 6f 75 20 |their lo|ok, you |
|000025a0| 63 68 61 6e 67 65 20 74 | 68 65 20 77 61 79 20 6e |change t|he way n|
|000025b0| 75 6d 62 65 72 73 20 61 | 72 65 20 66 6f 72 6d 61 |umbers a|re forma|
|000025c0| 74 74 65 64 2e 20 4f 66 | 20 63 6f 75 72 73 65 2c |tted. Of| course,|
|000025d0| 20 74 68 69 73 20 69 6d | 70 6c 69 65 73 20 74 68 | this im|plies th|
|000025e0| 61 74 20 79 6f 75 20 77 | 69 6c 6c 20 62 65 20 61 |at you w|ill be a|
|000025f0| 66 66 65 63 74 69 6e 67 | 20 63 65 6c 6c 73 20 77 |ffecting| cells w|
|00002600| 69 74 68 20 6e 75 6d 62 | 65 72 73 20 69 6e 20 74 |ith numb|ers in t|
|00002610| 68 65 6d 2e 0d 0d 54 68 | 65 72 65 20 69 73 20 61 |hem...Th|ere is a|
|00002620| 20 43 68 6f 6f 73 65 20 | 62 75 74 74 6f 6e 20 77 | Choose |button w|
|00002630| 68 69 63 68 20 64 69 73 | 70 6c 61 79 73 20 61 20 |hich dis|plays a |
|00002640| 6c 69 73 74 20 6f 66 20 | 66 6f 72 6d 61 74 73 20 |list of |formats |
|00002650| 79 6f 75 20 63 61 6e 20 | 75 73 65 20 66 6f 72 20 |you can |use for |
|00002660| 79 6f 75 72 20 6e 75 6d | 62 65 72 73 20 28 77 69 |your num|bers (wi|
|00002670| 74 68 20 64 6f 6c 6c 61 | 72 73 20 73 69 67 6e 73 |th dolla|rs signs|
|00002680| 2c 20 77 69 74 68 6f 75 | 74 2c 20 65 74 63 2e 29 |, withou|t, etc.)|
|00002690| 2e 20 54 68 65 20 64 65 | 66 61 75 6c 74 20 66 6f |. The de|fault fo|
|000026a0| 72 6d 61 74 74 69 6e 67 | 20 69 73 20 70 6c 61 69 |rmatting| is plai|
|000026b0| 6e 20 28 77 69 74 68 20 | 6e 6f 20 66 6f 72 6d 61 |n (with |no forma|
|000026c0| 74 74 69 6e 67 20 69 6e | 20 70 61 72 74 69 63 75 |tting in| particu|
|000026d0| 6c 61 72 29 2e 20 59 6f | 75 20 63 61 6e 20 61 6c |lar). Yo|u can al|
|000026e0| 73 6f 20 73 65 74 20 68 | 6f 77 20 6d 61 6e 79 20 |so set h|ow many |
|000026f0| 64 65 63 69 6d 61 6c 73 | 20 79 6f 75 d5 64 20 6c |decimals| you.d l|
|00002700| 69 6b 65 20 74 6f 20 73 | 65 65 2e 20 57 65 20 72 |ike to s|ee. We r|
|00002710| 65 63 6f 6d 6d 65 6e 64 | 20 74 68 61 74 20 79 6f |ecommend| that yo|
|00002720| 75 20 63 68 6f 6f 73 65 | 20 61 20 76 61 6c 75 65 |u choose| a value|
|00002730| 20 62 65 74 77 65 65 6e | 20 30 20 61 6e 64 20 39 | between| 0 and 9|
|00002740| 2e 20 57 68 65 6e 20 79 | 6f 75 d5 76 65 20 66 69 |. When y|ou.ve fi|
|00002750| 6e 69 73 68 65 64 2c 20 | 74 61 70 20 6f 6e 20 74 |nished, |tap on t|
|00002760| 68 65 20 52 65 74 75 72 | 6e 20 62 75 74 74 6f 6e |he Retur|n button|
|00002770| 20 74 6f 20 61 66 66 65 | 63 74 20 74 68 65 20 73 | to affe|ct the s|
|00002780| 65 6c 65 63 74 65 64 20 | 63 65 6c 6c 73 2e 0d 0d |elected |cells...|
|00002790| 53 45 4c 45 43 54 20 41 | 4e 44 20 4d 4f 56 45 0d |SELECT A|ND MOVE.|
|000027a0| 53 6f 6d 65 74 69 6d 65 | 73 2c 20 79 6f 75 20 6d |Sometime|s, you m|
|000027b0| 61 79 20 66 69 6e 64 20 | 74 68 61 74 20 74 68 65 |ay find |that the|
|000027c0| 20 64 61 74 61 20 79 6f | 75 20 65 6e 74 65 72 65 | data yo|u entere|
|000027d0| 64 20 69 73 20 6e 6f 74 | 20 77 68 65 72 65 20 79 |d is not| where y|
|000027e0| 6f 75 20 77 6f 75 6c 64 | 20 6c 69 6b 65 20 69 74 |ou would| like it|
|000027f0| 20 74 6f 20 62 65 2e 20 | 54 68 69 73 20 63 6f 6d | to be. |This com|
|00002800| 6d 61 6e 64 20 6c 65 74 | 73 20 79 6f 75 20 6d 6f |mand let|s you mo|
|00002810| 76 65 20 69 74 20 61 72 | 6f 75 6e 64 20 61 6e 79 |ve it ar|ound any|
|00002820| 77 68 65 72 65 20 6f 6e | 20 74 68 65 20 73 63 72 |where on| the scr|
|00002830| 65 65 6e 2e 20 54 68 65 | 20 66 69 72 73 74 20 74 |een. The| first t|
|00002840| 68 69 6e 67 20 79 6f 75 | 20 68 61 76 65 20 74 6f |hing you| have to|
|00002850| 20 64 6f 20 69 73 20 73 | 65 6c 65 63 74 20 74 68 | do is s|elect th|
|00002860| 65 20 63 6f 6d 6d 61 6e | 64 2e 20 4e 6f 77 2c 20 |e comman|d. Now, |
|00002870| 73 65 6c 65 63 74 20 74 | 68 65 20 63 65 6c 6c 20 |select t|he cell |
|00002880| 28 6f 72 20 63 65 6c 6c | 73 29 20 79 6f 75 d5 64 |(or cell|s) you.d|
|00002890| 20 6c 69 6b 65 20 74 6f | 20 6d 6f 76 65 20 28 73 | like to| move (s|
|000028a0| 65 65 20 74 68 65 20 53 | 65 74 20 41 74 74 72 69 |ee the S|et Attri|
|000028b0| 62 75 74 65 73 20 73 65 | 63 74 69 6f 6e 20 66 6f |butes se|ction fo|
|000028c0| 72 20 6d 6f 72 65 20 69 | 6e 66 6f 72 6d 61 74 69 |r more i|nformati|
|000028d0| 6f 6e 20 6f 6e 20 74 68 | 69 73 29 20 61 6e 64 20 |on on th|is) and |
|000028e0| 6c 69 66 74 20 75 70 20 | 74 68 65 20 70 65 6e 2e |lift up |the pen.|
|000028f0| 20 59 6f 75 72 20 73 65 | 6c 65 63 74 65 64 20 63 | Your se|lected c|
|00002900| 65 6c 6c 73 20 77 69 6c | 6c 20 73 74 61 79 20 68 |ells wil|l stay h|
|00002910| 69 67 68 6c 69 67 68 74 | 65 64 2e 20 54 6f 20 6d |ighlight|ed. To m|
|00002920| 6f 76 65 20 74 68 65 6d | 20 61 72 6f 75 6e 64 2c |ove them| around,|
|00002930| 20 74 61 70 20 6f 6e 63 | 65 20 6d 6f 72 65 20 69 | tap onc|e more i|
|00002940| 6e 20 74 68 65 20 73 65 | 6c 65 63 74 69 6f 6e 20 |n the se|lection |
|00002950| 72 65 63 74 61 6e 67 6c | 65 20 61 6e 64 20 6d 6f |rectangl|e and mo|
|00002960| 76 65 20 79 6f 75 72 20 | 70 65 6e 20 61 72 6f 75 |ve your |pen arou|
|00002970| 6e 64 2e 20 54 68 65 20 | 64 65 73 74 69 6e 61 74 |nd. The |destinat|
|00002980| 69 6f 6e 20 28 74 68 6f | 73 65 20 63 65 6c 6c 73 |ion (tho|se cells|
|00002990| 20 69 6e 74 6f 20 77 68 | 69 63 68 20 74 68 65 20 | into wh|ich the |
|000029a0| 73 65 6c 65 63 74 69 6f | 6e 20 77 69 6c 6c 20 62 |selectio|n will b|
|000029b0| 65 20 63 6f 70 69 65 64 | 29 20 77 69 6c 6c 20 62 |e copied|) will b|
|000029c0| 65 20 68 69 67 68 6c 69 | 67 68 74 65 64 20 69 6e |e highli|ghted in|
|000029d0| 20 62 6c 61 63 6b 2e 20 | 4d 6f 76 65 20 79 6f 75 | black. |Move you|
|000029e0| 72 20 70 65 6e 20 75 6e | 74 69 6c 20 74 68 65 20 |r pen un|til the |
|000029f0| 63 6f 72 72 65 63 74 20 | 73 65 74 20 6f 66 20 63 |correct |set of c|
|00002a00| 65 6c 6c 73 20 69 73 20 | 68 69 67 68 6c 69 67 68 |ells is |highligh|
|00002a10| 74 65 64 20 61 6e 64 20 | 6c 65 74 20 69 74 20 67 |ted and |let it g|
|00002a20| 6f 2e 20 59 6f 75 72 20 | 6f 72 69 67 69 6e 61 6c |o. Your |original|
|00002a30| 20 63 65 6c 6c 73 20 77 | 69 6c 6c 20 74 68 65 6e | cells w|ill then|
|00002a40| 20 62 65 20 65 6d 70 74 | 69 65 64 20 61 6e 64 20 | be empt|ied and |
|00002a50| 74 68 65 69 72 20 63 6f | 6e 74 65 6e 74 20 77 69 |their co|ntent wi|
|00002a60| 6c 6c 20 62 65 20 63 6f | 70 69 65 64 20 69 6e 74 |ll be co|pied int|
|00002a70| 6f 20 74 68 65 20 64 65 | 73 74 69 6e 61 74 69 6f |o the de|stinatio|
|00002a80| 6e 20 63 65 6c 6c 73 2e | 0d 0d 53 45 4c 45 43 54 |n cells.|..SELECT|
|00002a90| 20 41 4e 44 20 43 4f 50 | 59 0d 54 68 69 73 20 63 | AND COP|Y.This c|
|00002aa0| 6f 6d 6d 61 6e 64 20 77 | 6f 72 6b 73 20 74 68 65 |ommand w|orks the|
|00002ab0| 20 73 61 6d 65 20 77 61 | 79 20 61 73 20 74 68 65 | same wa|y as the|
|00002ac0| 20 53 65 6c 65 63 74 20 | 61 6e 64 20 4d 6f 76 65 | Select |and Move|
|00002ad0| 20 63 6f 6d 6d 61 6e 64 | 2c 20 65 78 63 65 70 74 | command|, except|
|00002ae0| 20 79 6f 75 72 20 6f 72 | 69 67 69 6e 61 6c 20 73 | your or|iginal s|
|00002af0| 65 6c 65 63 74 69 6f 6e | 20 69 73 20 6e 6f 74 20 |election| is not |
|00002b00| 65 72 61 73 65 64 2e 0d | 0d 53 45 4c 45 43 54 20 |erased..|.SELECT |
|00002b10| 41 4e 44 20 46 49 4c 4c | 0d 54 68 69 73 20 63 6f |AND FILL|.This co|
|00002b20| 6d 6d 61 6e 64 20 6c 65 | 74 73 20 79 6f 75 20 73 |mmand le|ts you s|
|00002b30| 61 76 65 20 74 69 6d 65 | 20 69 66 20 65 76 65 72 |ave time| if ever|
|00002b40| 20 79 6f 75 20 6e 65 65 | 64 20 74 6f 20 68 61 76 | you nee|d to hav|
|00002b50| 65 20 61 20 76 61 6c 75 | 65 20 6f 72 20 61 20 66 |e a valu|e or a f|
|00002b60| 6f 72 6d 75 6c 61 20 63 | 6f 70 69 65 64 20 69 6e |ormula c|opied in|
|00002b70| 74 6f 20 6d 61 6e 79 20 | 63 65 6c 6c 73 2e 20 54 |to many |cells. T|
|00002b80| 6f 20 64 6f 20 74 68 69 | 73 2c 20 73 65 6c 65 63 |o do thi|s, selec|
|00002b90| 74 20 74 68 65 20 53 65 | 6c 65 63 74 20 61 6e 64 |t the Se|lect and|
|00002ba0| 20 46 69 6c 6c 20 63 6f | 6d 6d 61 6e 64 20 66 72 | Fill co|mmand fr|
|00002bb0| 6f 6d 20 74 68 65 20 4f | 70 74 69 6f 6e 73 20 6d |om the O|ptions m|
|00002bc0| 65 6e 75 20 61 6e 64 20 | 73 65 6c 65 63 74 20 63 |enu and |select c|
|00002bd0| 65 6c 6c 73 20 79 6f 75 | d5 64 20 6c 69 6b 65 20 |ells you|.d like |
|00002be0| 74 6f 20 61 66 66 65 63 | 74 2e 20 54 68 65 20 66 |to affec|t. The f|
|00002bf0| 69 72 73 74 20 63 65 6c | 6c 20 28 65 69 74 68 65 |irst cel|l (eithe|
|00002c00| 72 20 74 68 65 20 74 6f | 70 6d 6f 73 74 20 6f 72 |r the to|pmost or|
|00002c10| 20 6c 65 66 74 6d 6f 73 | 74 20 63 65 6c 6c 2c 20 | leftmos|t cell, |
|00002c20| 64 65 70 65 6e 64 69 6e | 67 20 6f 6e 20 74 68 65 |dependin|g on the|
|00002c30| 20 6f 72 69 65 6e 74 61 | 74 69 6f 6e 20 6f 66 20 | orienta|tion of |
|00002c40| 79 6f 75 72 20 73 65 6c | 65 63 74 69 6f 6e 29 20 |your sel|ection) |
|00002c50| 77 69 6c 6c 20 62 65 20 | 63 6f 70 69 65 64 20 69 |will be |copied i|
|00002c60| 6e 74 6f 20 61 6c 6c 20 | 74 68 65 20 6f 74 68 65 |nto all |the othe|
|00002c70| 72 20 63 65 6c 6c 73 20 | 79 6f 75 20 73 65 6c 65 |r cells |you sele|
|00002c80| 63 74 65 64 2e 20 49 66 | 20 79 6f 75 20 64 65 63 |cted. If| you dec|
|00002c90| 69 64 65 20 74 6f 20 66 | 69 6c 6c 20 63 65 6c 6c |ide to f|ill cell|
|00002ca0| 73 20 77 69 74 68 20 61 | 20 66 6f 72 6d 75 6c 61 |s with a| formula|
|00002cb0| 2c 20 74 68 65 20 63 6f | 6f 72 64 69 6e 61 74 65 |, the co|ordinate|
|00002cc0| 73 20 69 6e 20 74 68 65 | 20 66 6f 72 6d 75 6c 61 |s in the| formula|
|00002cd0| 20 77 69 6c 6c 20 62 65 | 20 74 72 61 6e 73 70 6f | will be| transpo|
|00002ce0| 73 65 64 2e 20 46 6f 72 | 20 65 78 61 6d 70 6c 65 |sed. For| example|
|00002cf0| 2c 20 69 66 20 79 6f 75 | 20 64 65 63 69 64 65 20 |, if you| decide |
|00002d00| 74 6f 20 66 69 6c 6c 20 | 64 6f 77 6e 20 61 20 73 |to fill |down a s|
|00002d10| 65 72 69 65 73 20 6f 66 | 20 63 65 6c 6c 73 20 77 |eries of| cells w|
|00002d20| 69 74 68 20 74 68 65 20 | 66 6f 72 6d 75 6c 61 20 |ith the |formula |
|00002d30| d2 41 31 2b 31 d3 20 28 | 63 6f 6e 74 61 69 6e 65 |.A1+1. (|containe|
|00002d40| 64 20 69 6e 20 74 68 65 | 20 66 69 72 73 74 20 63 |d in the| first c|
|00002d50| 65 6c 6c 29 2c 20 79 6f | 75 72 20 66 6f 72 6d 75 |ell), yo|ur formu|
|00002d60| 6c 61 20 77 69 6c 6c 20 | 62 65 63 6f 6d 65 20 d2 |la will |become .|
|00002d70| 42 31 2b 31 d3 2c 20 d2 | 43 31 2b 31 d3 2c 20 d2 |B1+1., .|C1+1., .|
|00002d80| 44 31 2b 31 d3 2e 2e 2e | 0d 0d 41 74 20 74 68 65 |D1+1....|..At the|
|00002d90| 20 6d 6f 6d 65 6e 74 2c | 20 4e 61 70 6b 69 6e 20 | moment,| Napkin |
|00002da0| 43 61 6c 63 20 64 6f 65 | 73 20 6e 6f 74 20 73 75 |Calc doe|s not su|
|00002db0| 70 70 6f 72 74 20 32 44 | 20 66 69 6c 6c 73 20 28 |pport 2D| fills (|
|00002dc0| 66 6f 72 20 65 78 61 6d | 70 6c 65 2c 20 73 65 6c |for exam|ple, sel|
|00002dd0| 65 63 74 69 6e 67 20 36 | 20 63 65 6c 6c 73 2c 20 |ecting 6| cells, |
|00002de0| 74 68 65 20 66 69 72 73 | 74 20 33 20 62 65 69 6e |the firs|t 3 bein|
|00002df0| 67 20 63 6f 70 69 65 64 | 20 69 6e 74 6f 20 74 68 |g copied| into th|
|00002e00| 65 20 74 68 72 65 65 20 | 72 65 6d 61 69 6e 69 6e |e three |remainin|
|00002e10| 67 20 63 65 6c 6c 73 29 | 2e 20 41 6e 79 20 32 44 |g cells)|. Any 2D|
|00002e20| 20 73 65 6c 65 63 74 69 | 6f 6e 20 77 69 6c 6c 20 | selecti|on will |
|00002e30| 73 65 65 20 74 68 65 20 | 63 6f 6e 74 65 6e 74 73 |see the |contents|
|00002e40| 20 6f 66 20 74 68 65 20 | 66 69 72 73 74 20 63 65 | of the |first ce|
|00002e50| 6c 6c 20 63 6f 70 69 65 | 64 20 69 6e 74 6f 20 61 |ll copie|d into a|
|00002e60| 6c 6c 20 74 68 65 20 6f | 74 68 65 72 20 63 65 6c |ll the o|ther cel|
|00002e70| 6c 73 2c 20 77 68 65 74 | 68 65 72 20 74 68 65 79 |ls, whet|her they|
|00002e80| 20 62 65 20 6f 6e 20 61 | 20 64 69 66 66 65 72 65 | be on a| differe|
|00002e90| 6e 74 20 6c 69 6e 65 20 | 6f 72 20 69 6e 20 61 20 |nt line |or in a |
|00002ea0| 64 69 66 66 65 72 65 6e | 74 20 63 6f 6c 75 6d 6e |differen|t column|
|00002eb0| 2e 0d 0d 0d 52 4f 55 54 | 49 4e 47 0d 54 68 65 20 |....ROUT|ING.The |
|00002ec0| 62 75 74 74 6f 6e 20 77 | 69 74 68 20 74 68 65 20 |button w|ith the |
|00002ed0| 65 6e 76 65 6c 6f 70 65 | 20 6f 6e 20 69 74 20 69 |envelope| on it i|
|00002ee0| 73 20 63 61 6c 6c 65 64 | 20 74 68 65 20 52 6f 75 |s called| the Rou|
|00002ef0| 74 69 6e 67 20 62 75 74 | 74 6f 6e 2c 20 69 74 20 |ting but|ton, it |
|00002f00| 6c 65 74 73 20 79 6f 75 | 20 64 6f 20 61 20 66 65 |lets you| do a fe|
|00002f10| 77 20 6f 74 68 65 72 20 | 74 68 69 6e 67 73 20 77 |w other |things w|
|00002f20| 69 74 68 20 74 68 65 20 | 66 72 6f 6e 74 20 6d 6f |ith the |front mo|
|00002f30| 73 74 20 63 65 6c 6c 2e | 2e 2e 0d 0d 50 52 49 4e |st cell.|....PRIN|
|00002f40| 54 20 2f 20 46 41 58 20 | 53 48 45 45 54 0d 50 72 |T / FAX |SHEET.Pr|
|00002f50| 69 6e 74 73 20 28 6f 72 | 20 66 61 78 65 73 29 20 |ints (or| faxes) |
|00002f60| 74 68 65 20 63 75 72 72 | 65 6e 74 6c 79 20 73 65 |the curr|ently se|
|00002f70| 6c 65 63 74 65 64 20 28 | 69 65 3a 20 66 72 6f 6e |lected (|ie: fron|
|00002f80| 74 20 6d 6f 73 74 29 20 | 73 68 65 65 74 2e 20 49 |t most) |sheet. I|
|00002f90| 66 20 79 6f 75 72 20 73 | 68 65 65 74 20 69 73 20 |f your s|heet is |
|00002fa0| 72 61 74 68 65 72 20 6c | 61 72 67 65 2c 20 69 74 |rather l|arge, it|
|00002fb0| 20 6d 61 79 20 74 61 6b | 65 20 61 20 66 65 77 20 | may tak|e a few |
|00002fc0| 70 61 67 65 73 2e 20 53 | 65 65 20 79 6f 75 72 20 |pages. S|ee your |
|00002fd0| 64 65 76 69 63 65 d5 73 | 20 75 73 65 72 20 6d 61 |device.s| user ma|
|00002fe0| 6e 75 61 6c 20 66 6f 72 | 20 6d 6f 72 65 20 69 6e |nual for| more in|
|00002ff0| 66 6f 72 6d 61 74 69 6f | 6e 20 72 65 67 61 72 64 |formatio|n regard|
|00003000| 69 6e 67 20 74 68 65 73 | 65 20 63 6f 6d 6d 61 6e |ing thes|e comman|
|00003010| 64 73 2e 0d 0d 42 45 41 | 4d 0d 49 66 20 79 6f 75 |ds...BEA|M.If you|
|00003020| 20 68 61 76 65 20 73 6f | 6d 65 6f 6e 65 20 65 6c | have so|meone el|
|00003030| 73 65 20 77 68 6f 20 6f | 77 6e 73 20 61 20 63 6f |se who o|wns a co|
|00003040| 70 79 20 6f 66 20 4e 61 | 70 6b 69 6e 20 43 61 6c |py of Na|pkin Cal|
|00003050| 63 2c 20 61 6e 64 20 79 | 6f 75 d5 64 20 6c 69 6b |c, and y|ou.d lik|
|00003060| 65 20 74 6f 20 73 65 6e | 64 20 74 68 65 6d 20 61 |e to sen|d them a|
|00003070| 20 73 68 65 65 74 20 79 | 6f 75 d5 76 65 20 6d 61 | sheet y|ou.ve ma|
|00003080| 64 65 2c 20 74 68 69 73 | 20 63 6f 6d 6d 61 6e 64 |de, this| command|
|00003090| 20 77 69 6c 6c 20 6c 65 | 74 20 79 6f 75 20 64 6f | will le|t you do|
|000030a0| 20 74 68 69 73 2e 20 54 | 68 65 20 70 65 72 73 6f | this. T|he perso|
|000030b0| 6e 20 72 65 63 65 69 76 | 69 6e 67 20 74 68 65 20 |n receiv|ing the |
|000030c0| 73 68 65 65 74 20 77 69 | 6c 6c 20 68 61 76 65 20 |sheet wi|ll have |
|000030d0| 61 6e 20 65 78 61 63 74 | 20 63 6f 70 79 20 79 6f |an exact| copy yo|
|000030e0| 75 72 20 73 68 65 65 74 | 2e 0d 0d 4d 41 49 4c 0d |ur sheet|...MAIL.|
|000030f0| 49 66 20 74 68 61 74 20 | 73 6f 6d 65 6f 6e 65 20 |If that |someone |
|00003100| 79 6f 75 d5 64 20 6c 69 | 6b 65 20 74 6f 20 73 65 |you.d li|ke to se|
|00003110| 6e 64 20 61 20 73 68 65 | 65 74 20 74 6f 20 69 73 |nd a she|et to is|
|00003120| 20 6e 6f 74 20 69 6e 20 | 74 68 65 20 73 61 6d 65 | not in |the same|
|00003130| 20 62 75 69 6c 64 69 6e | 67 2c 20 79 6f 75 20 6d | buildin|g, you m|
|00003140| 69 67 68 74 20 77 61 6e | 74 20 74 6f 20 73 65 6e |ight wan|t to sen|
|00003150| 64 20 74 68 65 6d 20 79 | 6f 75 72 20 73 68 65 65 |d them y|our shee|
|00003160| 74 20 62 79 20 65 6c 65 | 63 74 72 6f 6e 69 63 20 |t by ele|ctronic |
|00003170| 6d 61 69 6c 2e 20 59 6f | 75 20 61 6c 73 6f 20 68 |mail. Yo|u also h|
|00003180| 61 76 65 20 74 68 65 20 | 6f 70 74 69 6f 6e 20 6f |ave the |option o|
|00003190| 66 20 73 65 6e 64 69 6e | 67 20 61 20 d2 74 65 78 |f sendin|g a .tex|
|000031a0| 74 20 6f 6e 6c 79 d3 20 | 63 6f 70 79 20 6f 66 20 |t only. |copy of |
|000031b0| 79 6f 75 72 20 73 68 65 | 65 74 2e 20 54 68 69 73 |your she|et. This|
|000031c0| 20 d2 74 65 78 74 20 6f | 6e 6c 79 d3 20 73 68 65 | .text o|nly. she|
|000031d0| 65 74 20 63 61 6e 20 62 | 65 20 73 65 65 6e 20 62 |et can b|e seen b|
|000031e0| 79 20 61 6e 79 6f 6e 65 | 20 77 69 74 68 20 65 2d |y anyone| with e-|
|000031f0| 6d 61 69 6c 2c 20 62 75 | 74 20 63 61 6e 20 6e 6f |mail, bu|t can no|
|00003200| 74 20 62 65 20 70 75 74 | 20 69 6e 74 6f 20 4e 61 |t be put| into Na|
|00003210| 70 6b 69 6e 20 43 61 6c | 63 2e 0d 0d 0d 44 45 4c |pkin Cal|c....DEL|
|00003220| 45 54 45 0d 44 65 6c 65 | 74 65 73 20 74 68 65 20 |ETE.Dele|tes the |
|00003230| 66 72 6f 6e 74 20 6d 6f | 73 74 20 73 68 65 65 74 |front mo|st sheet|
|00003240| 20 6f 6e 20 79 6f 75 72 | 20 73 63 72 65 65 6e 2e | on your| screen.|
|00003250| 20 54 68 69 73 20 63 6f | 6d 6d 61 6e 64 20 63 61 | This co|mmand ca|
|00003260| 6e 20 62 65 20 75 6e 64 | 6f 6e 65 2e 0d 0d 0d 44 |n be und|one....D|
|00003270| 55 50 4c 49 43 41 54 45 | 0d 4d 61 6b 65 73 20 61 |UPLICATE|.Makes a|
|00003280| 20 63 6f 70 79 20 6f 66 | 20 74 68 65 20 63 75 72 | copy of| the cur|
|00003290| 72 65 6e 74 20 73 68 65 | 65 74 20 61 6e 64 20 61 |rent she|et and a|
|000032a0| 64 64 73 20 d2 43 6f 70 | 79 20 6f 66 d3 20 69 6e |dds .Cop|y of. in|
|000032b0| 20 66 72 6f 6e 74 20 6f | 66 20 74 68 65 20 6e 61 | front o|f the na|
|000032c0| 6d 65 2e 20 54 68 69 73 | 20 63 6f 6d 6d 61 6e 64 |me. This| command|
|000032d0| 20 63 61 6e 20 62 65 20 | 75 6e 64 6f 6e 65 2e 0d | can be |undone..|
|000032e0| 0d 0d 4d 4f 56 45 20 46 | 52 4f 4d 2f 54 4f 20 43 |..MOVE F|ROM/TO C|
|000032f0| 41 52 44 0d 4a 75 73 74 | 20 69 6e 20 63 61 73 65 |ARD.Just| in case|
|00003300| 20 79 6f 75 20 64 69 64 | 6e d5 74 20 6b 6e 6f 77 | you did|n.t know|
|00003310| 2c 20 77 68 65 6e 20 79 | 6f 75 20 63 72 65 61 74 |, when y|ou creat|
|00003320| 65 20 61 20 6e 65 77 20 | 73 68 65 65 74 2c 20 69 |e a new |sheet, i|
|00003330| 74 20 63 61 6e 20 65 69 | 74 68 65 72 20 62 65 20 |t can ei|ther be |
|00003340| 73 74 6f 72 65 64 20 69 | 6e 20 49 6e 74 65 72 6e |stored i|n Intern|
|00003350| 61 6c 20 52 41 4d 20 6f | 72 20 6f 6e 20 61 20 52 |al RAM o|r on a R|
|00003360| 41 4d 20 63 61 72 64 20 | 28 69 66 20 79 6f 75 20 |AM card |(if you |
|00003370| 68 61 76 65 20 6f 6e 65 | 29 2e 20 48 6f 77 20 64 |have one|). How d|
|00003380| 6f 20 79 6f 75 20 6b 6e | 6f 77 20 77 68 65 72 65 |o you kn|ow where|
|00003390| 20 61 20 73 68 65 65 74 | 20 69 73 20 67 6f 69 6e | a sheet| is goin|
|000033a0| 67 20 74 6f 20 62 65 20 | 63 72 65 61 74 65 64 3f |g to be |created?|
|000033b0| 20 59 6f 75 20 64 65 63 | 69 64 65 2c 20 62 79 20 | You dec|ide, by |
|000033c0| 70 75 74 74 69 6e 67 20 | 61 20 63 68 65 63 6b 20 |putting |a check |
|000033d0| 69 6e 20 74 68 65 20 d2 | 53 74 6f 72 65 20 6e 65 |in the .|Store ne|
|000033e0| 77 20 69 74 65 6d 73 20 | 6f 6e 20 63 61 72 64 d3 |w items |on card.|
|000033f0| 20 62 75 74 74 6f 6e 20 | 28 69 6e 20 74 68 65 20 | button |(in the |
|00003400| 70 72 65 66 65 72 65 6e | 63 65 73 20 64 69 61 6c |preferen|ces dial|
|00003410| 6f 67 2c 20 61 63 63 65 | 73 73 69 62 6c 65 20 66 |og, acce|ssible f|
|00003420| 72 6f 6d 20 74 68 65 20 | 45 78 74 72 61 73 20 64 |rom the |Extras d|
|00003430| 72 61 77 65 72 29 2e 20 | 42 75 74 20 68 6f 77 20 |rawer). |But how |
|00003440| 64 6f 20 79 6f 75 20 72 | 65 6d 65 6d 62 65 72 20 |do you r|emember |
|00003450| 69 66 20 79 6f 75 72 20 | 73 68 65 65 74 73 20 68 |if your |sheets h|
|00003460| 61 76 65 20 62 65 65 6e | 20 63 72 65 61 74 65 64 |ave been| created|
|00003470| 20 61 20 77 68 69 6c 65 | 20 61 67 6f 3f 20 59 6f | a while| ago? Yo|
|00003480| 75 20 64 6f 6e d5 74 20 | 68 61 76 65 20 74 6f 21 |u don.t |have to!|
|00003490| 20 4e 6f 77 2c 20 77 68 | 65 6e 20 65 64 69 74 69 | Now, wh|en editi|
|000034a0| 6e 67 20 61 20 73 68 65 | 65 74 20 74 68 61 74 20 |ng a she|et that |
|000034b0| 69 73 20 73 74 6f 72 65 | 64 20 6f 6e 20 61 20 52 |is store|d on a R|
|000034c0| 41 4d 20 63 61 72 64 2c | 20 61 20 73 6d 61 6c 6c |AM card,| a small|
|000034d0| 20 74 72 69 61 6e 67 6c | 65 20 77 69 6c 6c 20 61 | triangl|e will a|
|000034e0| 70 70 65 61 72 20 61 74 | 20 74 68 65 20 72 69 67 |ppear at| the rig|
|000034f0| 68 74 20 6f 66 20 79 6f | 75 72 20 73 68 65 65 74 |ht of yo|ur sheet|
|00003500| d5 73 20 74 69 74 6c 65 | 2e 0d 0d 59 6f 75 20 63 |.s title|...You c|
|00003510| 61 6e 20 6d 6f 76 65 20 | 79 6f 75 72 20 73 68 65 |an move |your she|
|00003520| 65 74 20 46 52 4f 4d 20 | 74 68 65 20 52 41 4d 20 |et FROM |the RAM |
|00003530| 63 61 72 64 20 69 6e 74 | 6f 20 49 6e 74 65 72 6e |card int|o Intern|
|00003540| 61 6c 20 6d 65 6d 6f 72 | 79 20 28 6f 72 20 76 69 |al memor|y (or vi|
|00003550| 63 65 20 76 65 72 73 61 | 29 20 77 69 74 68 20 74 |ce versa|) with t|
|00003560| 68 65 20 d2 4d 6f 76 65 | 20 46 72 6f 6d 2f 54 6f |he .Move| From/To|
|00003570| 20 63 61 72 64 d3 20 6f | 70 74 69 6f 6e 20 69 6e | card. o|ption in|
|00003580| 20 74 68 65 20 52 6f 75 | 74 69 6e 67 20 6d 65 6e | the Rou|ting men|
|00003590| 75 2e 20 49 66 20 79 6f | 75 20 6d 6f 76 65 20 61 |u. If yo|u move a|
|000035a0| 20 73 68 65 65 74 20 66 | 72 6f 6d 20 61 20 63 61 | sheet f|rom a ca|
|000035b0| 72 64 20 69 6e 74 6f 20 | 49 6e 74 65 72 6e 61 6c |rd into |Internal|
|000035c0| 20 52 41 4d 2c 20 74 68 | 65 20 74 72 69 61 6e 67 | RAM, th|e triang|
|000035d0| 6c 65 20 77 69 6c 6c 20 | 64 69 73 61 70 70 65 61 |le will |disappea|
|000035e0| 72 20 74 6f 20 69 6e 64 | 69 63 61 74 65 20 77 68 |r to ind|icate wh|
|000035f0| 65 72 65 20 74 68 65 20 | 6c 69 73 74 20 69 73 20 |ere the |list is |
|00003600| 73 74 6f 72 65 64 2e 0d | 0d 0d 46 4f 52 4d 55 4c |stored..|..FORMUL|
|00003610| 41 53 0d 4f 66 20 63 6f | 75 72 73 65 2c 20 77 68 |AS.Of co|urse, wh|
|00003620| 69 63 68 20 73 70 72 65 | 61 64 73 68 65 65 74 20 |ich spre|adsheet |
|00003630| 77 6f 75 6c 64 20 62 65 | 20 63 6f 6d 70 6c 65 74 |would be| complet|
|00003640| 65 20 77 69 74 68 6f 75 | 74 20 61 20 77 61 79 20 |e withou|t a way |
|00003650| 6f 66 20 65 6e 74 65 72 | 69 6e 67 20 66 6f 72 6d |of enter|ing form|
|00003660| 75 6c 61 73 2e 20 50 6c | 65 61 73 65 20 72 65 6d |ulas. Pl|ease rem|
|00003670| 65 6d 62 65 72 2c 20 74 | 68 6f 75 67 68 2c 20 74 |ember, t|hough, t|
|00003680| 68 61 74 20 4e 61 70 6b | 69 6e 20 43 61 6c 63 20 |hat Napk|in Calc |
|00003690| 61 69 6d 73 20 74 6f 20 | 62 65 20 61 20 73 69 6d |aims to |be a sim|
|000036a0| 70 6c 65 20 70 72 6f 67 | 72 61 6d 20 77 69 74 68 |ple prog|ram with|
|000036b0| 20 73 69 6d 70 6c 65 20 | 66 6f 72 6d 75 6c 61 73 | simple |formulas|
|000036c0| 2e 20 57 65 20 64 6f 20 | 6e 6f 74 20 77 69 73 68 |. We do |not wish|
|000036d0| 20 74 6f 20 72 65 70 72 | 6f 64 75 63 65 20 61 6c | to repr|oduce al|
|000036e0| 6c 20 74 68 65 20 66 75 | 6e 63 74 69 6f 6e 73 20 |l the fu|nctions |
|000036f0| 74 68 61 74 20 63 61 6e | 20 62 65 20 66 6f 75 6e |that can| be foun|
|00003700| 64 20 6f 6e 20 73 6f 6d | 65 20 6f 66 20 74 68 65 |d on som|e of the|
|00003710| 20 6d 6f 72 65 20 70 6f | 77 65 72 66 75 6c 20 61 | more po|werful a|
|00003720| 70 70 6c 69 63 61 74 69 | 6f 6e 73 20 61 6c 73 6f |pplicati|ons also|
|00003730| 20 61 76 61 69 6c 61 62 | 6c 65 2e 20 53 6f 20 65 | availab|le. So e|
|00003740| 76 65 72 79 74 68 69 6e | 67 20 79 6f 75 20 64 65 |verythin|g you de|
|00003750| 73 69 72 65 20 6d 69 67 | 68 74 20 6e 6f 74 20 62 |sire mig|ht not b|
|00003760| 65 20 69 6e 20 68 65 72 | 65 2e 2e 2e 20 79 65 74 |e in her|e... yet|
|00003770| 21 0d 0d 54 6f 20 73 65 | 65 20 74 68 65 20 66 6f |!..To se|e the fo|
|00003780| 72 6d 75 6c 61 20 65 64 | 69 74 6f 72 2c 20 79 6f |rmula ed|itor, yo|
|00003790| 75 20 68 61 76 65 20 61 | 20 66 65 77 20 6f 70 74 |u have a| few opt|
|000037a0| 69 6f 6e 73 2e 20 54 68 | 65 20 73 69 6d 70 6c 65 |ions. Th|e simple|
|000037b0| 73 74 20 6f 6e 65 20 69 | 73 20 74 6f 20 65 6e 74 |st one i|s to ent|
|000037c0| 65 72 20 61 20 d2 2d d3 | 20 69 6e 20 61 6e 20 65 |er a .-.| in an e|
|000037d0| 6d 70 74 79 20 63 65 6c | 6c 2e 20 54 68 69 73 20 |mpty cel|l. This |
|000037e0| 77 69 6c 6c 20 61 75 74 | 6f 6d 61 74 69 63 61 6c |will aut|omatical|
|000037f0| 6c 79 20 62 72 69 6e 67 | 20 75 70 20 74 68 65 20 |ly bring| up the |
|00003800| 66 6f 72 6d 75 6c 61 20 | 65 64 69 74 6f 72 2e 20 |formula |editor. |
|00003810| 4f 74 68 65 72 20 6f 70 | 74 69 6f 6e 73 20 69 6e |Other op|tions in|
|00003820| 63 6c 75 64 65 20 64 6f | 75 62 6c 65 20 74 61 70 |clude do|uble tap|
|00003830| 70 69 6e 67 20 6f 6e 20 | 61 20 63 65 6c 6c 20 28 |ping on |a cell (|
|00003840| 69 66 20 79 6f 75 20 73 | 65 74 20 79 6f 75 72 20 |if you s|et your |
|00003850| 70 72 65 66 65 72 65 6e | 63 65 73 20 74 6f 20 6f |preferen|ces to o|
|00003860| 70 65 6e 20 74 68 65 20 | 66 6f 72 6d 75 6c 61 20 |pen the |formula |
|00003870| 65 64 69 74 6f 72 20 6f | 6e 20 61 20 64 6f 75 62 |editor o|n a doub|
|00003880| 6c 65 20 74 61 70 29 2c | 20 6f 72 20 64 6f 75 62 |le tap),| or doub|
|00003890| 6c 65 20 74 61 70 70 69 | 6e 67 20 6f 6e 20 61 20 |le tappi|ng on a |
|000038a0| 63 65 6c 6c 20 77 68 69 | 63 68 20 61 6c 72 65 61 |cell whi|ch alrea|
|000038b0| 64 79 20 68 6f 6c 64 73 | 20 61 20 66 6f 72 6d 75 |dy holds| a formu|
|000038c0| 6c 61 2e 20 49 6e 20 74 | 68 69 73 20 6c 61 73 74 |la. In t|his last|
|000038d0| 20 63 61 73 65 2c 20 74 | 68 65 20 65 64 69 74 6f | case, t|he edito|
|000038e0| 72 20 77 69 6c 6c 20 61 | 6c 77 61 79 73 20 6f 70 |r will a|lways op|
|000038f0| 65 6e 2c 20 77 68 61 74 | 65 76 65 72 20 79 6f 75 |en, what|ever you|
|00003900| 72 20 70 72 65 66 65 72 | 65 6e 63 65 73 20 6d 69 |r prefer|ences mi|
|00003910| 67 68 74 20 73 61 79 2e | 0d 0d 57 68 65 6e 20 74 |ght say.|..When t|
|00003920| 68 65 20 64 69 61 6c 6f | 67 20 69 73 20 6f 70 65 |he dialo|g is ope|
|00003930| 6e 2c 20 6f 6e 65 20 6f | 66 20 74 68 65 20 74 68 |n, one o|f the th|
|00003940| 69 6e 67 73 20 79 6f 75 | 20 73 65 65 20 69 73 20 |ings you| see is |
|00003950| 74 68 65 20 63 6f 6f 72 | 64 69 6e 61 74 65 20 6f |the coor|dinate o|
|00003960| 66 20 74 68 65 20 63 65 | 6c 6c 20 69 6e 20 77 68 |f the ce|ll in wh|
|00003970| 69 63 68 20 74 68 65 20 | 66 6f 72 6d 75 6c 61 20 |ich the |formula |
|00003980| 69 73 20 67 6f 69 6e 67 | 20 74 6f 20 62 65 20 70 |is going| to be p|
|00003990| 75 74 20 69 6e 74 6f 20 | 28 61 74 20 74 68 65 20 |ut into |(at the |
|000039a0| 74 6f 70 20 6c 65 66 74 | 20 6f 66 20 74 68 65 20 |top left| of the |
|000039b0| 64 69 61 6c 6f 67 29 2e | 20 4e 65 78 74 20 74 6f |dialog).| Next to|
|000039c0| 20 74 68 61 74 20 69 73 | 20 74 68 65 20 73 70 61 | that is| the spa|
|000039d0| 63 65 20 77 68 65 72 65 | 20 74 68 65 20 61 63 74 |ce where| the act|
|000039e0| 75 61 6c 20 66 6f 72 6d | 75 6c 61 20 63 61 6e 20 |ual form|ula can |
|000039f0| 62 65 20 65 69 74 68 65 | 72 20 77 72 69 74 74 65 |be eithe|r writte|
|00003a00| 6e 20 69 6e 20 62 79 20 | 68 61 6e 64 2c 20 6f 72 |n in by |hand, or|
|00003a10| 20 65 6e 74 65 72 65 64 | 20 77 69 74 68 20 73 6f | entered| with so|
|00003a20| 6d 65 20 6f 66 20 74 68 | 65 20 76 61 72 69 6f 75 |me of th|e variou|
|00003a30| 73 20 62 75 74 74 6f 6e | 73 20 61 76 61 69 6c 61 |s button|s availa|
|00003a40| 62 6c 65 2e 20 54 68 65 | 20 66 6f 72 6d 75 6c 61 |ble. The| formula|
|00003a50| 20 69 74 73 65 6c 66 20 | 63 61 6e 20 62 65 20 6d | itself |can be m|
|00003a60| 61 6e 69 70 75 6c 61 74 | 65 64 20 74 68 65 20 77 |anipulat|ed the w|
|00003a70| 61 79 20 6e 6f 72 6d 61 | 6c 20 74 65 78 74 20 75 |ay norma|l text u|
|00003a80| 73 75 61 6c 6c 79 20 69 | 73 2c 20 77 69 74 68 20 |sually i|s, with |
|00003a90| 74 68 65 20 70 65 6e 2e | 0d 0d 41 6c 6c 20 66 6f |the pen.|..All fo|
|00003aa0| 72 6d 75 6c 61 73 20 6d | 75 73 74 20 62 65 67 69 |rmulas m|ust begi|
|00003ab0| 6e 20 77 69 74 68 20 d2 | 3d d3 2e 20 54 68 69 73 |n with .|=.. This|
|00003ac0| 20 69 73 20 77 68 79 20 | 74 68 65 72 65 20 69 73 | is why |there is|
|00003ad0| 20 61 20 d2 3d d3 20 62 | 75 74 74 6f 6e 2e 20 49 | a .=. b|utton. I|
|00003ae0| 66 20 79 6f 75 20 65 76 | 65 72 20 68 61 70 70 65 |f you ev|er happe|
|00003af0| 6e 20 74 6f 20 65 72 61 | 73 65 20 69 74 20 62 79 |n to era|se it by|
|00003b00| 20 61 63 63 69 64 65 6e | 74 2c 20 79 6f 75 20 63 | acciden|t, you c|
|00003b10| 61 6e 20 61 6c 77 61 79 | 73 20 70 61 73 74 65 20 |an alway|s paste |
|00003b20| 69 74 20 62 61 63 6b 20 | 69 6e 2e 0d 0d 54 68 65 |it back |in...The|
|00003b30| 20 6e 75 6d 62 65 72 73 | 20 62 75 74 74 6f 6e 73 | numbers| buttons|
|00003b40| 20 73 69 6d 70 6c 79 20 | 61 64 64 20 61 20 6e 75 | simply |add a nu|
|00003b50| 6d 62 65 72 20 69 6e 20 | 74 68 65 20 66 6f 72 6d |mber in |the form|
|00003b60| 75 6c 61 2e 20 54 68 65 | 20 6f 70 65 72 61 74 6f |ula. The| operato|
|00003b70| 72 73 20 62 75 74 74 6f | 6e 73 20 28 2a 2c 20 2f |rs butto|ns (*, /|
|00003b80| 2c 20 2b 2c 20 2d 29 20 | 61 72 65 20 61 6c 73 6f |, +, -) |are also|
|00003b90| 20 66 61 69 72 6c 79 20 | 73 74 72 61 69 67 68 74 | fairly |straight|
|00003ba0| 66 6f 72 77 61 72 64 2e | 0d 0d 59 6f 75 72 20 66 |forward.|..Your f|
|00003bb0| 6f 72 6d 75 6c 61 20 63 | 6f 75 6c 64 20 62 65 20 |ormula c|ould be |
|00003bc0| 61 73 20 73 69 6d 70 6c | 65 20 61 73 20 d2 37 2a |as simpl|e as .7*|
|00003bd0| 33 d3 2e 20 42 79 20 74 | 61 70 70 69 6e 67 20 6f |3.. By t|apping o|
|00003be0| 6e 20 74 68 65 20 52 65 | 74 75 72 6e 20 62 75 74 |n the Re|turn but|
|00003bf0| 74 6f 6e 20 28 74 68 65 | 20 6f 6e 65 20 61 62 6f |ton (the| one abo|
|00003c00| 76 65 20 74 68 65 20 64 | 69 61 6c 6f 67 d5 73 20 |ve the d|ialog.s |
|00003c10| 63 6c 6f 73 65 20 62 6f | 78 29 2c 20 79 6f 75 d5 |close bo|x), you.|
|00003c20| 64 20 73 65 65 20 d2 32 | 31 d3 20 61 70 70 65 61 |d see .2|1. appea|
|00003c30| 72 20 69 6e 20 74 68 65 | 20 63 65 6c 6c 20 79 6f |r in the| cell yo|
|00003c40| 75 20 77 61 6e 74 65 64 | 20 74 6f 20 61 66 66 65 |u wanted| to affe|
|00003c50| 63 74 2e 0d 0d 4f 66 20 | 63 6f 75 72 73 65 2c 20 |ct...Of |course, |
|00003c60| 73 6f 6d 65 74 69 6d 65 | 73 20 79 6f 75 20 77 61 |sometime|s you wa|
|00003c70| 6e 74 20 61 20 62 69 74 | 20 6d 6f 72 65 20 66 6c |nt a bit| more fl|
|00003c80| 65 78 69 62 69 6c 69 74 | 79 20 74 68 61 6e 20 74 |exibilit|y than t|
|00003c90| 68 61 74 2e 20 49 66 20 | 79 6f 75 20 77 61 6e 74 |hat. If |you want|
|00003ca0| 20 79 6f 75 72 20 66 6f | 72 6d 75 6c 61 20 74 6f | your fo|rmula to|
|00003cb0| 20 62 65 20 d2 42 32 2b | 34 d3 20 28 42 32 20 62 | be .B2+|4. (B2 b|
|00003cc0| 65 69 6e 67 20 74 68 65 | 20 63 6f 6f 72 64 69 6e |eing the| coordin|
|00003cd0| 61 74 65 20 6f 66 20 61 | 20 63 65 6c 6c 20 77 68 |ate of a| cell wh|
|00003ce0| 6f d5 73 20 63 6f 6e 74 | 65 6e 74 20 79 6f 75 20 |o.s cont|ent you |
|00003cf0| 77 69 73 68 20 74 6f 20 | 75 73 65 20 69 6e 20 74 |wish to |use in t|
|00003d00| 68 65 20 63 61 6c 63 75 | 6c 61 74 69 6f 6e 29 2c |he calcu|lation),|
|00003d10| 20 74 61 70 20 6f 6e 20 | 74 68 65 20 63 65 6c 6c | tap on |the cell|
|00003d20| 20 77 68 69 63 68 20 77 | 6f 75 6c 64 20 62 65 20 | which w|ould be |
|00003d30| 42 32 2c 20 74 68 65 6e | 20 74 61 70 20 6f 6e 20 |B2, then| tap on |
|00003d40| 74 68 65 20 d2 2b d3 20 | 61 6e 64 20 6f 6e 20 74 |the .+. |and on t|
|00003d50| 68 65 20 d2 34 d3 2e 20 | 57 68 65 6e 20 79 6f 75 |he .4.. |When you|
|00003d60| 20 74 61 70 20 6f 6e 20 | 72 65 74 75 72 6e 2c 20 | tap on |return, |
|00003d70| 4e 61 70 6b 69 6e 20 43 | 61 6c 63 20 77 69 6c 6c |Napkin C|alc will|
|00003d80| 20 74 61 6b 65 20 74 68 | 65 20 63 6f 6e 74 65 6e | take th|e conten|
|00003d90| 74 20 6f 66 20 42 32 2c | 20 61 64 64 20 34 20 74 |t of B2,| add 4 t|
|00003da0| 6f 20 69 74 20 61 6e 64 | 20 73 68 6f 77 20 79 6f |o it and| show yo|
|00003db0| 75 20 74 68 65 20 72 65 | 73 75 6c 74 2e 20 49 66 |u the re|sult. If|
|00003dc0| 20 79 6f 75 20 64 65 63 | 69 64 65 20 74 6f 20 63 | you dec|ide to c|
|00003dd0| 68 61 6e 67 65 20 42 32 | d5 73 20 76 61 6c 75 65 |hange B2|.s value|
|00003de0| 2c 20 74 68 65 20 63 61 | 6c 63 75 6c 61 74 69 6f |, the ca|lculatio|
|00003df0| 6e d5 73 20 72 65 73 75 | 6c 74 20 77 69 6c 6c 20 |n.s resu|lt will |
|00003e00| 61 6c 73 6f 20 62 65 20 | 75 70 64 61 74 65 64 2e |also be |updated.|
|00003e10| 0d 0d 4e 61 74 75 72 61 | 6c 6c 79 2c 20 73 6f 6d |..Natura|lly, som|
|00003e20| 65 74 69 6d 65 73 20 79 | 6f 75 20 6e 65 65 64 20 |etimes y|ou need |
|00003e30| 74 6f 20 64 6f 20 6d 6f | 72 65 20 74 68 61 6e 20 |to do mo|re than |
|00003e40| 73 69 6d 70 6c 65 20 61 | 72 69 74 68 6d 65 74 69 |simple a|rithmeti|
|00003e50| 63 73 2c 20 73 6f 20 77 | 65 20 69 6e 63 6c 75 64 |cs, so w|e includ|
|00003e60| 65 64 20 61 20 66 65 77 | 20 62 61 73 69 63 20 66 |ed a few| basic f|
|00003e70| 75 6e 63 74 69 6f 6e 73 | 20 77 65 20 74 68 6f 75 |unctions| we thou|
|00003e80| 67 68 74 20 79 6f 75 20 | 6d 69 67 68 74 20 66 69 |ght you |might fi|
|00003e90| 6e 64 20 75 73 65 66 75 | 6c 2e 20 41 6c 6d 6f 73 |nd usefu|l. Almos|
|00003ea0| 74 20 61 6c 6c 20 6f 66 | 20 74 68 65 73 65 20 63 |t all of| these c|
|00003eb0| 6f 6d 6d 61 6e 64 73 20 | 6c 6f 6f 6b 20 6c 69 6b |ommands |look lik|
|00003ec0| 65 20 74 68 69 73 3a ca | 3c 63 6f 6d 6d 61 6e 64 |e this:.|<command|
|00003ed0| 20 6e 61 6d 65 3e 28 29 | 2e 20 54 68 65 20 70 61 | name>()|. The pa|
|00003ee0| 72 65 6e 74 68 65 73 69 | 73 20 77 69 6c 6c 20 68 |renthesi|s will h|
|00003ef0| 6f 6c 64 20 74 68 65 20 | 76 61 6c 75 65 73 20 79 |old the |values y|
|00003f00| 6f 75 20 77 69 73 68 20 | 74 6f 20 68 61 76 65 20 |ou wish |to have |
|00003f10| 74 68 65 20 66 75 6e 63 | 74 69 6f 6e 20 61 66 66 |the func|tion aff|
|00003f20| 65 63 74 20 6f 72 20 75 | 73 65 2e 20 54 68 65 79 |ect or u|se. They|
|00003f30| 20 63 61 6e 20 62 65 20 | 65 69 74 68 65 72 20 61 | can be |either a|
|00003f40| 20 6e 75 6d 62 65 72 2c | 20 61 20 63 65 6c 6c 20 | number,| a cell |
|00003f50| 63 6f 6f 72 64 69 6e 61 | 74 65 2c 20 6f 72 20 61 |coordina|te, or a|
|00003f60| 20 6c 69 73 74 20 6f 66 | 20 63 65 6c 6c 73 2e 20 | list of| cells. |
|00003f70| 54 68 69 73 20 64 65 70 | 65 6e 64 73 20 6f 6e 20 |This dep|ends on |
|00003f80| 74 68 65 20 73 65 6c 65 | 63 74 65 64 20 66 75 6e |the sele|cted fun|
|00003f90| 63 74 69 6f 6e 2e 0d 0d | 4f 75 72 20 66 75 6e 63 |ction...|Our func|
|00003fa0| 74 69 6f 6e 73 20 61 72 | 65 20 64 69 76 69 64 65 |tions ar|e divide|
|00003fb0| 64 20 69 6e 20 63 61 74 | 65 67 6f 72 69 65 73 2e |d in cat|egories.|
|00003fc0| 20 54 68 69 73 20 77 69 | 6c 6c 20 68 65 6c 70 20 | This wi|ll help |
|00003fd0| 79 6f 75 20 66 69 6e 64 | 20 74 68 65 6d 20 66 61 |you find| them fa|
|00003fe0| 73 74 65 72 2e 20 48 65 | 72 65 20 69 73 20 61 20 |ster. He|re is a |
|00003ff0| 72 75 6e 64 6f 77 6e 20 | 6f 66 20 77 68 61 74 20 |rundown |of what |
|00004000| 74 68 6f 73 65 20 66 75 | 6e 63 74 69 6f 6e 73 20 |those fu|nctions |
|00004010| 61 72 65 20 61 6e 64 20 | 77 68 61 74 20 74 68 65 |are and |what the|
|00004020| 79 20 65 78 70 65 63 74 | 20 74 6f 20 66 69 6e 64 |y expect| to find|
|00004030| 20 62 65 74 77 65 65 6e | 20 74 68 65 69 72 20 70 | between| their p|
|00004040| 61 72 65 6e 74 68 65 73 | 69 73 2e 20 49 74 20 63 |arenthes|is. It c|
|00004050| 61 6e 20 62 65 20 65 69 | 74 68 65 72 20 6f 66 20 |an be ei|ther of |
|00004060| 74 77 6f 20 74 68 69 6e | 67 73 3a ca d2 6e 75 6d |two thin|gs:..num|
|00004070| 62 65 72 d3 20 6f 72 20 | d2 6c 69 73 74 d3 2e 20 |ber. or |.list.. |
|00004080| 49 66 20 69 74 20 73 61 | 79 73 20 d2 6e 75 6d 62 |If it sa|ys .numb|
|00004090| 65 72 d3 2c 20 74 68 61 | 6e 20 74 68 65 20 66 75 |er., tha|n the fu|
|000040a0| 6e 63 74 69 6f 6e 20 65 | 78 70 65 63 74 73 20 61 |nction e|xpects a|
|000040b0| 20 73 69 6d 70 6c 65 20 | 6e 75 6d 62 65 72 20 6f | simple |number o|
|000040c0| 72 20 61 20 63 65 6c 6c | 20 72 65 66 65 72 65 6e |r a cell| referen|
|000040d0| 63 65 2e 20 49 66 20 69 | 74 d5 73 20 d2 6c 69 73 |ce. If i|t.s .lis|
|000040e0| 74 d3 2c 20 74 68 61 6e | 20 69 74 20 65 78 70 65 |t., than| it expe|
|000040f0| 63 74 73 20 73 6f 6d 65 | 74 68 69 6e 67 20 6c 69 |cts some|thing li|
|00004100| 6b 65 20 d2 41 32 3a 41 | 35 d3 2e 20 54 6f 20 73 |ke .A2:A|5.. To s|
|00004110| 65 6c 65 63 74 20 61 20 | 6c 69 73 74 20 6f 66 20 |elect a |list of |
|00004120| 63 65 6c 6c 73 2c 20 73 | 65 65 20 74 68 65 20 53 |cells, s|ee the S|
|00004130| 65 74 20 41 74 74 72 69 | 62 75 74 65 73 20 63 6f |et Attri|butes co|
|00004140| 6d 6d 61 6e 64 2e 20 54 | 68 65 20 73 65 6c 65 63 |mmand. T|he selec|
|00004150| 74 65 64 20 72 61 6e 67 | 65 20 77 69 6c 6c 20 70 |ted rang|e will p|
|00004160| 75 74 20 69 74 73 65 6c | 66 20 61 75 74 6f 6d 61 |ut itsel|f automa|
|00004170| 74 69 63 61 6c 6c 79 20 | 62 65 74 77 65 65 6e 20 |tically |between |
|00004180| 74 68 65 20 70 61 72 65 | 6e 74 68 65 73 69 73 2e |the pare|nthesis.|
|00004190| 0d 0d 53 54 41 54 53 0d | 54 68 65 73 65 20 61 72 |..STATS.|These ar|
|000041a0| 65 20 66 75 6e 63 74 69 | 6f 6e 73 20 74 68 61 74 |e functi|ons that|
|000041b0| 20 68 65 6c 70 20 79 6f | 75 20 77 69 74 68 20 73 | help yo|u with s|
|000041c0| 74 61 74 69 73 74 69 63 | 61 6c 20 63 61 6c 63 75 |tatistic|al calcu|
|000041d0| 6c 61 74 69 6f 6e 73 2e | 0d 0d 41 56 47 28 6c 69 |lations.|..AVG(li|
|000041e0| 73 74 29 3a 20 63 61 6c | 63 75 6c 61 74 65 73 20 |st): cal|culates |
|000041f0| 74 68 65 20 61 76 65 72 | 61 67 65 20 6f 66 20 61 |the aver|age of a|
|00004200| 20 6c 69 73 74 20 6f 66 | 20 63 65 6c 6c 73 2e 0d | list of| cells..|
|00004210| 0d 43 4f 55 4e 54 28 6c | 69 73 74 29 3a 20 63 6f |.COUNT(l|ist): co|
|00004220| 75 6e 74 73 20 68 6f 77 | 20 6d 61 6e 79 20 63 65 |unts how| many ce|
|00004230| 6c 6c 73 20 68 61 76 65 | 20 73 6f 6d 65 20 6e 75 |lls have| some nu|
|00004240| 6d 65 72 69 63 61 6c 20 | 63 6f 6e 74 65 6e 74 20 |merical |content |
|00004250| 69 6e 20 74 68 65 6d 2e | 0d 0d 4d 41 58 28 6c 69 |in them.|..MAX(li|
|00004260| 73 74 29 3a 20 72 65 74 | 75 72 6e 73 20 74 68 65 |st): ret|urns the|
|00004270| 20 68 69 67 68 65 73 74 | 20 76 61 6c 75 65 20 69 | highest| value i|
|00004280| 6e 20 61 20 6c 69 73 74 | 20 6f 66 20 63 65 6c 6c |n a list| of cell|
|00004290| 73 2e 0d 0d 4d 49 4e 28 | 6c 69 73 74 29 3a 20 72 |s...MIN(|list): r|
|000042a0| 65 74 75 72 6e 73 20 74 | 68 65 20 6c 6f 77 65 73 |eturns t|he lowes|
|000042b0| 74 20 76 61 6c 75 65 20 | 69 6e 20 61 20 6c 69 73 |t value |in a lis|
|000042c0| 74 20 6f 66 20 63 65 6c | 6c 73 2e 0d 0d 53 54 44 |t of cel|ls...STD|
|000042d0| 44 45 56 28 6c 69 73 74 | 29 3a 20 63 61 6c 63 75 |DEV(list|): calcu|
|000042e0| 6c 61 74 65 73 20 74 68 | 65 20 73 61 6d 70 6c 65 |lates th|e sample|
|000042f0| 20 73 74 61 6e 64 61 72 | 64 20 64 65 76 69 61 74 | standar|d deviat|
|00004300| 69 6f 6e 20 28 6c 65 61 | 73 74 20 73 71 75 61 72 |ion (lea|st squar|
|00004310| 65 73 20 6d 65 74 68 6f | 64 29 20 75 73 69 6e 67 |es metho|d) using|
|00004320| 20 74 68 65 20 76 61 6c | 75 65 73 20 69 6e 20 74 | the val|ues in t|
|00004330| 68 65 20 6c 69 73 74 20 | 6f 66 20 63 65 6c 6c 73 |he list |of cells|
|00004340| 2e 0d 0d 53 55 4d 28 6c | 69 73 74 29 3a 20 70 65 |...SUM(l|ist): pe|
|00004350| 72 66 6f 72 6d 73 20 61 | 6e 20 61 64 64 69 74 69 |rforms a|n additi|
|00004360| 6f 6e 20 6f 6e 20 61 6c | 6c 20 74 68 65 20 73 65 |on on al|l the se|
|00004370| 6c 65 63 74 65 64 20 63 | 65 6c 6c 73 2e 0d 0d 56 |lected c|ells...V|
|00004380| 41 52 28 6c 69 73 74 29 | 3a 20 63 61 6c 63 75 6c |AR(list)|: calcul|
|00004390| 61 74 65 73 20 74 68 65 | 20 73 61 6d 70 6c 65 20 |ates the| sample |
|000043a0| 76 61 72 69 61 6e 63 65 | 20 6f 66 20 74 68 65 20 |variance| of the |
|000043b0| 76 61 6c 75 65 73 20 66 | 6f 75 6e 64 20 69 6e 20 |values f|ound in |
|000043c0| 74 68 65 20 6c 69 73 74 | 20 6f 66 20 63 65 6c 6c |the list| of cell|
|000043d0| 73 2e 0d 0d 0d 46 49 4e | 41 4e 2e 0d 54 68 65 73 |s....FIN|AN..Thes|
|000043e0| 65 20 61 72 65 20 66 75 | 6e 63 74 69 6f 6e 73 20 |e are fu|nctions |
|000043f0| 74 68 61 74 20 68 65 6c | 70 20 79 6f 75 20 77 69 |that hel|p you wi|
|00004400| 74 20 63 61 6c 63 75 6c | 61 74 69 6f 6e 73 20 6f |t calcul|ations o|
|00004410| 66 20 61 6e 20 65 63 6f | 6e 6f 6d 69 63 20 6e 61 |f an eco|nomic na|
|00004420| 74 75 72 65 2e 20 50 6c | 65 61 73 65 20 6e 6f 74 |ture. Pl|ease not|
|00004430| 65 20 61 6e 20 69 6d 70 | 6f 72 74 61 6e 74 20 6c |e an imp|ortant l|
|00004440| 69 6d 69 74 61 74 69 6f | 6e 20 6f 66 20 4e 61 70 |imitatio|n of Nap|
|00004450| 6b 69 6e 20 43 61 6c 63 | 2e 20 59 6f 75 20 63 61 |kin Calc|. You ca|
|00004460| 6e 20 6e 6f 74 20 65 6e | 74 65 72 20 61 20 72 61 |n not en|ter a ra|
|00004470| 74 65 20 73 75 63 68 20 | 61 73 20 46 56 28 70 61 |te such |as FV(pa|
|00004480| 79 6d 65 6e 74 2c 20 28 | 2e 30 31 2f 31 32 29 2c |yment, (|.01/12),|
|00004490| 20 6e 62 20 6f 66 20 70 | 61 79 6d 65 6e 74 73 29 | nb of p|ayments)|
|000044a0| 2e 20 54 68 61 74 20 69 | 73 20 74 6f 20 73 61 79 |. That i|s to say|
|000044b0| 20 74 68 61 74 20 79 6f | 75 20 63 61 6e 20 6e 6f | that yo|u can no|
|000044c0| 74 20 69 6e 63 6c 75 64 | 65 20 61 20 66 6f 72 6d |t includ|e a form|
|000044d0| 75 6c 61 20 61 73 20 61 | 20 70 61 72 61 6d 65 74 |ula as a| paramet|
|000044e0| 65 72 20 69 6e 20 61 6e | 79 20 6f 66 20 74 68 65 |er in an|y of the|
|000044f0| 20 66 69 6e 61 6e 63 69 | 61 6c 20 66 75 6e 63 74 | financi|al funct|
|00004500| 69 6f 6e 73 20 62 65 6c | 6f 77 2e 20 59 6f 75 20 |ions bel|ow. You |
|00004510| 63 61 6e 20 65 6e 74 65 | 72 20 74 68 65 20 72 65 |can ente|r the re|
|00004520| 73 75 6c 74 20 28 30 2e | 31 2f 31 32 20 3d 20 30 |sult (0.|1/12 = 0|
|00004530| 2e 30 30 38 33 33 33 29 | 20 6f 72 20 70 6c 61 63 |.008333)| or plac|
|00004540| 65 20 74 68 65 20 66 6f | 72 6d 75 6c 61 20 69 6e |e the fo|rmula in|
|00004550| 20 61 6e 6f 74 68 65 72 | 20 63 65 6c 6c 20 61 6e | another| cell an|
|00004560| 64 20 75 73 65 20 74 68 | 65 20 63 65 6c 6c 20 72 |d use th|e cell r|
|00004570| 65 66 65 72 65 6e 63 65 | 20 69 6e 73 74 65 61 64 |eference| instead|
|00004580| 2e 0d 0d 41 4e 4e 55 49 | 54 59 28 72 61 74 65 20 |...ANNUI|TY(rate |
|00004590| 3b 20 6e 62 20 6f 66 20 | 70 65 72 69 6f 64 73 29 |; nb of |periods)|
|000045a0| 3a 20 63 61 6c 63 75 6c | 61 74 65 73 20 74 68 65 |: calcul|ates the|
|000045b0| 20 61 6e 6e 75 69 74 79 | 20 61 73 20 64 65 74 65 | annuity| as dete|
|000045c0| 72 6d 69 6e 65 64 20 62 | 79 20 74 68 65 20 76 61 |rmined b|y the va|
|000045d0| 6c 75 65 73 20 6f 66 20 | d2 72 61 74 65 d3 20 61 |lues of |.rate. a|
|000045e0| 6e 64 20 d2 6e 62 20 6f | 66 20 70 65 72 69 6f 64 |nd .nb o|f period|
|000045f0| 73 d3 2e 0d 0d 43 4f 4d | 50 4f 55 4e 44 28 72 61 |s....COM|POUND(ra|
|00004600| 74 65 20 3b 20 6e 62 20 | 6f 66 20 70 65 72 69 6f |te ; nb |of perio|
|00004610| 64 73 29 3a 20 63 61 6c | 63 75 6c 61 74 65 73 20 |ds): cal|culates |
|00004620| 74 68 65 20 63 6f 6d 70 | 6f 75 6e 64 20 69 6e 74 |the comp|ound int|
|00004630| 65 72 65 73 74 20 61 73 | 20 64 65 74 65 72 6d 69 |erest as| determi|
|00004640| 6e 65 64 20 62 79 20 74 | 68 65 20 76 61 6c 75 65 |ned by t|he value|
|00004650| 73 20 6f 66 20 d2 72 61 | 74 65 d3 20 61 6e 64 20 |s of .ra|te. and |
|00004660| d2 6e 62 20 6f 66 20 70 | 65 72 69 6f 64 73 d3 2e |.nb of p|eriods..|
|00004670| 0d 0d 44 42 28 69 6e 76 | 65 73 74 6d 65 6e 74 20 |..DB(inv|estment |
|00004680| 3b 20 74 65 72 6d 20 3b | 20 72 61 74 65 20 3b 20 |; term ;| rate ; |
|00004690| 70 65 72 69 6f 64 29 3a | 20 72 65 74 75 72 6e 73 |period):| returns|
|000046a0| 20 74 68 65 20 64 65 70 | 72 65 63 69 61 74 69 6f | the dep|reciatio|
|000046b0| 6e 20 61 6d 6f 75 6e 74 | 20 66 6f 72 20 61 20 73 |n amount| for a s|
|000046c0| 70 65 63 69 66 69 63 20 | 70 65 72 69 6f 64 2c 20 |pecific |period, |
|000046d0| 62 61 73 65 64 20 6f 6e | 20 74 68 65 20 6f 72 69 |based on| the ori|
|000046e0| 67 69 6e 61 6c 20 69 6e | 76 65 73 74 6d 65 6e 74 |ginal in|vestment|
|000046f0| 2c 20 74 68 65 20 6e 75 | 6d 62 65 72 20 6f 66 20 |, the nu|mber of |
|00004700| 70 65 72 69 6f 64 73 20 | 6f 76 65 72 20 77 68 69 |periods |over whi|
|00004710| 63 68 20 74 6f 20 64 65 | 70 72 65 63 69 61 74 65 |ch to de|preciate|
|00004720| 20 61 6e 64 20 61 20 73 | 74 72 61 69 67 68 74 2d | and a s|traight-|
|00004730| 6c 69 6e 65 20 72 61 74 | 65 20 6d 75 6c 74 69 70 |line rat|e multip|
|00004740| 6c 69 65 72 2e 0d 0d 46 | 56 28 70 61 79 6d 65 6e |lier...F|V(paymen|
|00004750| 74 20 3b 20 72 61 74 65 | 20 3b 20 6e 62 20 6f 66 |t ; rate| ; nb of|
|00004760| 20 70 61 79 6d 65 6e 74 | 73 29 3a 20 72 65 74 75 | payment|s): retu|
|00004770| 72 6e 73 20 74 68 65 20 | 66 75 74 75 72 65 20 76 |rns the |future v|
|00004780| 61 6c 75 65 20 28 63 6f | 6d 70 6f 75 6e 64 65 64 |alue (co|mpounded|
|00004790| 29 20 62 61 73 65 64 20 | 6f 6e 20 69 6e 74 65 72 |) based |on inter|
|000047a0| 65 73 74 73 20 65 61 72 | 6e 65 64 20 64 75 72 69 |ests ear|ned duri|
|000047b0| 6e 67 20 70 61 79 6d 65 | 6e 74 73 20 6f 76 65 72 |ng payme|nts over|
|000047c0| 20 61 20 63 65 72 74 61 | 69 6e 20 70 65 72 69 6f | a certa|in perio|
|000047d0| 64 2e 20 d2 50 61 79 6d | 65 6e 74 d3 20 69 73 20 |d. .Paym|ent. is |
|000047e0| 74 68 65 20 61 6d 6f 75 | 6e 74 20 6f 66 20 65 61 |the amou|nt of ea|
|000047f0| 63 68 20 70 61 79 6d 65 | 6e 74 2c 20 d2 72 61 74 |ch payme|nt, .rat|
|00004800| 65 d3 20 69 73 20 74 68 | 65 20 69 6e 74 65 72 65 |e. is th|e intere|
|00004810| 73 74 20 72 61 74 65 20 | 70 65 72 20 70 65 72 69 |st rate |per peri|
|00004820| 6f 64 20 61 6e 64 20 d2 | 6e 62 20 6f 66 20 70 61 |od and .|nb of pa|
|00004830| 79 6d 65 6e 74 73 d3 20 | 69 73 20 74 68 65 20 64 |yments. |is the d|
|00004840| 75 72 61 74 69 6f 6e 2e | 0d 0d 50 4d 54 28 70 72 |uration.|..PMT(pr|
|00004850| 69 6e 63 69 70 61 6c 20 | 3b 20 72 61 74 65 20 3b |incipal |; rate ;|
|00004860| 20 74 65 72 6d 29 3a 20 | 63 61 6c 63 75 6c 61 74 | term): |calculat|
|00004870| 65 73 20 68 6f 77 20 6d | 75 63 68 20 79 6f 75 20 |es how m|uch you |
|00004880| 6d 75 73 74 20 70 61 79 | 20 66 6f 72 20 65 61 63 |must pay| for eac|
|00004890| 68 20 70 65 72 69 6f 64 | 2c 20 62 61 73 65 64 20 |h period|, based |
|000048a0| 6f 6e 20 74 68 65 20 70 | 65 72 69 6f 64 69 63 20 |on the p|eriodic |
|000048b0| 72 61 74 65 20 79 6f 75 | 20 65 6e 74 65 72 65 64 |rate you| entered|
|000048c0| 2c 20 61 6e 64 20 66 6f | 72 20 74 68 65 20 61 6d |, and fo|r the am|
|000048d0| 6f 75 6e 74 20 6f 66 20 | 74 69 6d 65 20 73 70 65 |ount of |time spe|
|000048e0| 63 69 66 69 65 64 20 62 | 79 20 d2 74 65 72 6d d3 |cified b|y .term.|
|000048f0| 2e 0d 0d 50 56 28 70 61 | 79 6d 65 6e 74 20 3b 20 |...PV(pa|yment ; |
|00004900| 72 61 74 65 20 3b 20 6e | 62 20 6f 66 20 70 61 79 |rate ; n|b of pay|
|00004910| 6d 65 6e 74 73 29 3a 20 | 72 65 74 75 72 6e 73 20 |ments): |returns |
|00004920| 74 68 65 20 76 61 6c 75 | 65 20 6f 66 20 61 20 73 |the valu|e of a s|
|00004930| 65 72 69 65 73 20 6f 66 | 20 70 61 79 6d 65 6e 74 |eries of| payment|
|00004940| 73 2c 20 62 61 73 65 64 | 20 6f 6e 20 61 20 70 65 |s, based| on a pe|
|00004950| 72 69 6f 64 69 63 20 69 | 6e 74 65 72 65 73 74 20 |riodic i|nterest |
|00004960| 72 61 74 65 20 61 6e 64 | 20 61 20 64 75 72 61 74 |rate and| a durat|
|00004970| 69 6f 6e 20 6f 66 20 d2 | 6e 62 20 6f 66 20 70 61 |ion of .|nb of pa|
|00004980| 79 6d 65 6e 74 73 d3 2e | 0d 0d 53 4c 28 69 6e 76 |yments..|..SL(inv|
|00004990| 65 73 74 6d 65 6e 74 20 | 3b 20 72 65 73 69 64 75 |estment |; residu|
|000049a0| 61 6c 20 3b 20 6e 62 20 | 6f 66 20 70 65 72 69 6f |al ; nb |of perio|
|000049b0| 64 73 29 3a 20 72 65 74 | 75 72 6e 73 20 74 68 65 |ds): ret|urns the|
|000049c0| 20 73 74 72 61 69 67 68 | 74 2d 6c 69 6e 65 20 64 | straigh|t-line d|
|000049d0| 65 70 72 65 63 69 61 74 | 69 6f 6e 20 61 6d 6f 75 |epreciat|ion amou|
|000049e0| 6e 74 2c 20 62 61 73 65 | 64 20 6f 6e 20 d2 69 6e |nt, base|d on .in|
|000049f0| 76 65 73 74 6d 65 6e 74 | d3 2c 20 66 6f 72 20 61 |vestment|., for a|
|00004a00| 20 73 65 72 69 65 73 20 | 6f 66 20 70 65 72 69 6f | series |of perio|
|00004a10| 64 73 2c 20 61 6e 64 20 | 66 6f 72 20 74 68 65 20 |ds, and |for the |
|00004a20| 64 75 72 61 74 69 6f 6e | 20 6f 66 20 d2 6e 62 20 |duration| of .nb |
|00004a30| 6f 66 20 70 65 72 69 6f | 64 73 2e d3 0d 0d 0d 47 |of perio|ds.....G|
|00004a40| 45 4e 2e 0d 55 73 65 64 | 20 66 6f 72 20 67 65 6e |EN..Used| for gen|
|00004a50| 65 72 61 6c 20 6d 61 74 | 68 65 6d 61 74 69 63 61 |eral mat|hematica|
|00004a60| 6c 20 70 75 72 70 6f 73 | 65 73 2e 0d 0d 41 42 53 |l purpos|es...ABS|
|00004a70| 28 6e 75 6d 62 65 72 29 | 3a 20 72 65 74 75 72 6e |(number)|: return|
|00004a80| 73 20 74 68 65 20 61 62 | 73 6f 6c 75 74 65 20 28 |s the ab|solute (|
|00004a90| 70 6f 73 69 74 69 76 65 | 29 20 76 61 6c 75 65 20 |positive|) value |
|00004aa0| 6f 66 20 61 20 6e 75 6d | 62 65 72 20 2e 0d 0d 45 |of a num|ber ...E|
|00004ab0| 58 50 28 6e 75 6d 62 65 | 72 29 3a 20 72 65 74 75 |XP(numbe|r): retu|
|00004ac0| 72 6e 73 20 65 20 72 61 | 69 73 65 64 20 74 6f 20 |rns e ra|ised to |
|00004ad0| 74 68 65 20 70 6f 77 65 | 72 20 79 6f 75 20 73 70 |the powe|r you sp|
|00004ae0| 65 63 69 66 79 20 77 69 | 74 68 20 d2 6e 75 6d 62 |ecify wi|th .numb|
|00004af0| 65 72 d3 2e 0d 0d 49 46 | 28 78 3b 79 3b 7a 29 3a |er....IF|(x;y;z):|
|00004b00| 20 69 66 20 74 68 65 20 | 76 61 6c 75 65 20 6f 66 | if the |value of|
|00004b10| 20 d2 78 d3 20 69 73 20 | 64 69 66 66 65 72 65 6e | .x. is |differen|
|00004b20| 74 20 74 68 61 6e 20 7a | 65 72 6f 2c 20 49 46 20 |t than z|ero, IF |
|00004b30| 72 65 74 75 72 6e 73 20 | d2 79 d3 2c 20 69 66 20 |returns |.y., if |
|00004b40| d2 78 d3 20 69 73 20 65 | 71 75 61 6c 20 74 6f 20 |.x. is e|qual to |
|00004b50| 7a 65 72 6f 2c 20 d2 7a | d3 20 69 73 20 72 65 74 |zero, .z|. is ret|
|00004b60| 75 72 6e 65 64 2e 0d 0d | 4c 4e 28 6e 75 6d 62 65 |urned...|LN(numbe|
|00004b70| 72 29 3a 20 72 65 74 75 | 72 6e 73 20 74 68 65 20 |r): retu|rns the |
|00004b80| 6e 61 74 75 72 61 6c 20 | 6c 6f 67 61 72 69 74 68 |natural |logarith|
|00004b90| 6d 2c 20 6f 72 20 6c 6f | 67 20 62 61 73 65 20 65 |m, or lo|g base e|
|00004ba0| 2c 20 6f 66 20 d2 6e 75 | 6d 62 65 72 d3 2e 0d 0d |, of .nu|mber....|
|00004bb0| 4c 4f 47 28 6e 75 6d 62 | 65 72 29 3a 20 72 65 74 |LOG(numb|er): ret|
|00004bc0| 75 72 6e 73 20 74 68 65 | 20 63 6f 6d 6d 6f 6e 20 |urns the| common |
|00004bd0| 6c 6f 67 61 72 69 74 68 | 6d 2c 20 6f 72 20 6c 6f |logarith|m, or lo|
|00004be0| 67 20 62 61 73 20 31 30 | 2c 20 6f 66 20 d2 6e 75 |g bas 10|, of .nu|
|00004bf0| 6d 62 65 72 d3 2e 0d 0d | 50 4f 57 28 78 3b 79 29 |mber....|POW(x;y)|
|00004c00| 3a 20 72 65 74 75 72 6e | 73 20 74 68 65 20 76 61 |: return|s the va|
|00004c10| 6c 75 65 20 6f 66 20 78 | 20 74 6f 20 74 68 65 20 |lue of x| to the |
|00004c20| 79 74 68 20 70 6f 77 65 | 72 20 28 65 78 3a ca 50 |yth powe|r (ex:.P|
|00004c30| 4f 57 28 33 3b 32 29 20 | 72 65 74 75 72 6e 73 20 |OW(3;2) |returns |
|00004c40| 39 29 2e 0d 0d 52 41 4e | 44 28 78 3b 79 29 3a ca |9)...RAN|D(x;y):.|
|00004c50| 72 65 74 75 72 6e 73 20 | 61 20 72 61 6e 64 6f 6d |returns |a random|
|00004c60| 20 6e 75 6d 62 65 72 20 | 62 65 74 77 65 65 6e 20 | number |between |
|00004c70| 78 20 61 6e 64 20 79 2e | 0d 0d 52 4f 55 4e 44 28 |x and y.|..ROUND(|
|00004c80| 6e 75 6d 62 65 72 29 3a | 20 72 6f 75 6e 64 73 20 |number):| rounds |
|00004c90| 74 68 65 20 6e 75 6d 62 | 65 72 20 74 6f 20 7a 65 |the numb|er to ze|
|00004ca0| 72 6f 20 64 65 63 69 6d | 61 6c 73 2e 0d 0d 53 51 |ro decim|als...SQ|
|00004cb0| 52 54 28 6e 75 6d 62 65 | 72 29 3a 20 72 65 74 75 |RT(numbe|r): retu|
|00004cc0| 72 6e 73 20 74 68 65 20 | 73 71 75 61 72 65 20 72 |rns the |square r|
|00004cd0| 6f 6f 74 20 6f 66 20 61 | 20 6e 75 6d 62 65 72 2e |oot of a| number.|
|00004ce0| 0d 0d 0d 54 52 49 47 2e | 0d 54 68 65 73 65 20 66 |...TRIG.|.These f|
|00004cf0| 75 6e 63 74 69 6f 6e 73 | 20 61 72 65 20 66 6f 72 |unctions| are for|
|00004d00| 20 74 72 69 67 6f 6e 6f | 6d 69 63 61 6c 20 63 61 | trigono|mical ca|
|00004d10| 6c 63 75 6c 61 74 69 6f | 6e 73 2e 20 41 6c 6c 20 |lculatio|ns. All |
|00004d20| 6f 66 20 74 68 65 6d 20 | 66 6f 6c 6c 6f 77 20 74 |of them |follow t|
|00004d30| 68 65 20 3c 66 75 6e 63 | 74 69 6f 6e 3e 28 6e 75 |he <func|tion>(nu|
|00004d40| 6d 62 65 72 29 20 70 61 | 74 74 65 72 6e 2e 20 45 |mber) pa|ttern. E|
|00004d50| 78 63 65 70 74 20 50 49 | 20 77 68 69 63 68 20 73 |xcept PI| which s|
|00004d60| 69 6d 70 6c 79 20 72 65 | 74 75 72 6e 73 20 33 2e |imply re|turns 3.|
|00004d70| 31 34 31 35 39 32 37 2e | 20 54 68 65 73 65 20 63 |1415927.| These c|
|00004d80| 6f 6d 6d 61 6e 64 73 20 | 61 72 65 3a ca 41 43 4f |ommands |are:.ACO|
|00004d90| 53 28 29 2c 20 41 53 49 | 4e 28 29 2c 20 41 54 41 |S(), ASI|N(), ATA|
|00004da0| 4e 28 29 2c 20 41 54 41 | 4e 32 28 78 3b 79 29 2c |N(), ATA|N2(x;y),|
|00004db0| 20 43 4f 53 28 29 2c 20 | 50 49 28 29 2c 20 53 49 | COS(), |PI(), SI|
|00004dc0| 4e 28 29 2c 20 54 41 4e | 28 29 2e 0d 0d 41 6c 73 |N(), TAN|()...Als|
|00004dd0| 6f 2c 20 41 54 41 4e 32 | 28 78 3b 79 29 20 67 69 |o, ATAN2|(x;y) gi|
|00004de0| 76 65 73 20 74 68 65 20 | 61 72 63 74 61 6e 67 65 |ves the |arctange|
|00004df0| 6e 74 20 6f 66 20 78 20 | 61 6e 64 20 79 2e 20 44 |nt of x |and y. D|
|00004e00| 6f 6e d5 74 20 66 6f 72 | 67 65 74 20 74 6f 20 65 |on.t for|get to e|
|00004e10| 6e 74 65 72 20 74 77 6f | 20 76 61 6c 75 65 73 20 |nter two| values |
|00004e20| 66 6f 72 20 74 68 69 73 | 20 66 75 6e 63 74 69 6f |for this| functio|
|00004e30| 6e 2e 0d 0d 0d 54 49 50 | 53 20 4f 4e 20 53 50 45 |n....TIP|S ON SPE|
|00004e40| 45 44 0d 4e 61 70 6b 69 | 6e 20 43 61 6c 63 2c 20 |ED.Napki|n Calc, |
|00004e50| 61 6c 74 68 6f 75 67 68 | 20 6e 6f 20 73 70 65 65 |although| no spee|
|00004e60| 64 20 64 65 6d 6f 6e 2c | 20 73 74 69 6c 6c 20 72 |d demon,| still r|
|00004e70| 75 6e 73 20 61 74 20 64 | 65 63 65 6e 74 20 73 70 |uns at d|ecent sp|
|00004e80| 65 65 64 73 2e 20 57 65 | d5 72 65 20 61 6c 72 65 |eeds. We|.re alre|
|00004e90| 61 64 79 20 77 6f 72 6b | 69 6e 67 20 6f 6e 20 77 |ady work|ing on w|
|00004ea0| 61 79 73 20 74 6f 20 73 | 70 65 65 64 20 75 70 20 |ays to s|peed up |
|00004eb0| 74 68 69 6e 67 73 2c 20 | 62 75 74 20 69 6e 20 74 |things, |but in t|
|00004ec0| 68 65 20 6d 65 61 6e 20 | 74 69 6d 65 2c 20 68 65 |he mean |time, he|
|00004ed0| 72 65 20 61 72 65 20 61 | 20 66 65 77 20 74 68 69 |re are a| few thi|
|00004ee0| 6e 67 73 20 79 6f 75 20 | 63 61 6e 20 64 6f 20 74 |ngs you |can do t|
|00004ef0| 68 61 74 20 6d 69 67 68 | 74 20 68 65 6c 70 20 74 |hat migh|t help t|
|00004f00| 68 65 20 70 65 72 66 6f | 72 6d 61 6e 63 65 2e 0d |he perfo|rmance..|
|00004f10| 0d 54 68 65 20 6d 6f 72 | 65 20 66 6f 72 6d 75 6c |.The mor|e formul|
|00004f20| 61 73 20 79 6f 75 20 68 | 61 76 65 20 69 6e 20 61 |as you h|ave in a|
|00004f30| 20 73 68 65 65 74 2c 20 | 74 68 65 20 6c 6f 6e 67 | sheet, |the long|
|00004f40| 65 72 20 69 74 d5 6c 6c | 20 74 61 6b 65 20 74 6f |er it.ll| take to|
|00004f50| 20 75 70 64 61 74 65 20 | 69 74 73 65 6c 66 20 77 | update |itself w|
|00004f60| 68 65 6e 20 79 6f 75 20 | 65 6e 74 65 72 20 61 20 |hen you |enter a |
|00004f70| 6e 65 77 20 6e 75 6d 62 | 65 72 2e 20 43 6f 6d 62 |new numb|er. Comb|
|00004f80| 69 6e 69 6e 67 20 66 6f | 72 6d 75 6c 61 73 20 6d |ining fo|rmulas m|
|00004f90| 69 67 68 74 20 73 6f 6d | 65 74 69 6d 65 73 20 62 |ight som|etimes b|
|00004fa0| 65 20 61 20 73 6f 6c 75 | 74 69 6f 6e 2e 0d 0d 49 |e a solu|tion...I|
|00004fb0| 74 20 6d 61 79 20 62 65 | 20 66 61 73 74 65 72 20 |t may be| faster |
|00004fc0| 66 6f 72 20 79 6f 75 20 | 74 6f 20 73 65 70 61 72 |for you |to separ|
|00004fd0| 61 74 65 20 79 6f 75 72 | 20 64 61 74 61 20 69 6e |ate your| data in|
|00004fe0| 20 73 65 76 65 72 61 6c | 20 73 6d 61 6c 6c 20 73 | several| small s|
|00004ff0| 68 65 65 74 73 20 72 61 | 74 68 65 72 20 74 68 61 |heets ra|ther tha|
|00005000| 6e 20 6f 6e 65 20 62 69 | 67 20 73 68 65 65 74 2e |n one bi|g sheet.|
|00005010| 20 54 68 69 73 20 69 73 | 20 6d 6f 72 65 20 70 72 | This is| more pr|
|00005020| 61 63 74 69 63 61 6c 20 | 69 66 20 79 6f 75 20 68 |actical |if you h|
|00005030| 61 76 65 20 6d 61 6e 79 | 20 66 6f 72 6d 75 6c 61 |ave many| formula|
|00005040| 73 2e 0d 0d 4b 65 65 70 | 69 6e 67 20 73 68 65 65 |s...Keep|ing shee|
|00005050| 74 20 73 69 7a 65 73 20 | 74 6f 20 61 20 6d 69 6e |t sizes |to a min|
|00005060| 69 6d 75 6d 20 61 6c 73 | 6f 20 68 65 6c 70 73 2e |imum als|o helps.|
|00005070| 20 4e 61 70 6b 69 6e 20 | 43 61 6c 63 20 77 69 74 | Napkin |Calc wit|
|00005080| 68 20 64 69 73 70 6c 61 | 79 20 61 20 73 68 65 65 |h displa|y a shee|
|00005090| 74 20 73 68 6f 77 69 6e | 67 20 32 30 20 63 65 6c |t showin|g 20 cel|
|000050a0| 6c 73 20 61 20 6c 6f 74 | 20 66 61 73 74 65 72 20 |ls a lot| faster |
|000050b0| 74 68 61 6e 20 6f 6e 65 | 20 77 69 74 68 20 34 30 |than one| with 40|
|000050c0| 20 63 65 6c 6c 73 2e 20 | 54 68 69 73 20 77 69 6c | cells. |This wil|
|000050d0| 6c 20 61 6c 73 6f 20 68 | 65 6c 70 20 79 6f 75 20 |l also h|elp you |
|000050e0| 73 61 76 65 20 6d 65 6d | 6f 72 79 2e 0d 0d 0d 52 |save mem|ory....R|
|000050f0| 45 56 49 53 49 4f 4e 53 | 20 2d 20 4f 52 20 57 48 |EVISIONS| - OR WH|
|00005100| 41 54 d5 53 20 4e 45 57 | 20 57 49 54 48 20 55 0d |AT.S NEW| WITH U.|
|00005110| 54 68 69 73 20 69 73 20 | 77 68 65 72 65 20 79 6f |This is |where yo|
|00005120| 75 20 63 61 6e 20 73 65 | 65 20 74 68 65 20 65 76 |u can se|e the ev|
|00005130| 6f 6c 75 74 69 6f 6e 20 | 6f 66 20 4e 61 70 6b 69 |olution |of Napki|
|00005140| 6e 20 43 61 6c 63 2e 20 | 49 74 20 61 20 71 75 69 |n Calc. |It a qui|
|00005150| 63 6b 20 77 61 79 20 74 | 6f 20 6c 65 61 72 6e 20 |ck way t|o learn |
|00005160| 77 68 61 74 d5 73 20 62 | 65 65 6e 20 68 61 70 70 |what.s b|een happ|
|00005170| 65 6e 69 6e 67 20 73 69 | 6e 63 65 20 74 68 65 20 |ening si|nce the |
|00005180| 6c 61 73 74 20 76 65 72 | 73 69 6f 6e 20 79 6f 75 |last ver|sion you|
|00005190| 20 68 61 64 2e 0d 0d 4e | 61 70 6b 69 6e 20 43 61 | had...N|apkin Ca|
|000051a0| 6c 63 20 31 2e 31 3a 20 | 49 74 d5 73 20 61 62 6f |lc 1.1: |It.s abo|
|000051b0| 75 74 20 74 69 6d 65 21 | 0d 20 2d 20 4e 65 77 20 |ut time!|. - New |
|000051c0| 6f 70 74 69 6f 6e 20 74 | 6f 20 73 68 6f 77 2f 68 |option t|o show/h|
|000051d0| 69 64 65 20 68 65 61 64 | 65 72 73 0d 20 2d 20 4e |ide head|ers. - N|
|000051e0| 6f 77 20 72 65 6d 65 6d | 62 65 72 73 20 6c 6f 63 |ow remem|bers loc|
|000051f0| 61 74 69 6f 6e 20 6f 66 | 20 73 68 65 65 74 73 0d |ation of| sheets.|
|00005200| 20 2d 20 4f 70 74 69 6f | 6e 20 74 6f 20 72 65 6d | - Optio|n to rem|
|00005210| 65 6d 62 65 72 20 6f 70 | 65 6e 65 64 20 73 68 65 |ember op|ened she|
|00005220| 65 74 73 20 62 65 66 6f | 72 65 20 63 6c 6f 73 69 |ets befo|re closi|
|00005230| 6e 67 0d 20 2d 20 4e 65 | 77 20 66 75 6e 63 74 69 |ng. - Ne|w functi|
|00005240| 6f 6e 3a ca 52 41 4e 44 | 28 78 2c 79 29 0d 20 2d |on:.RAND|(x,y). -|
|00005250| 20 4e 65 77 20 46 75 6e | 63 74 69 6f 6e 3a 20 49 | New Fun|ction: I|
|00005260| 46 28 78 2c 79 2c 7a 29 | 0d 20 2d 20 52 65 6d 65 |F(x,y,z)|. - Reme|
|00005270| 6d 62 65 72 73 20 61 74 | 74 72 69 62 75 74 65 73 |mbers at|tributes|
|00005280| 20 66 6f 72 20 65 6d 70 | 74 79 20 63 65 6c 6c 73 | for emp|ty cells|
|00005290| 0d 20 2d 20 46 6f 72 6d | 75 6c 61 20 65 64 69 74 |. - Form|ula edit|
|000052a0| 6f 72 20 68 61 73 20 6d | 6f 72 65 20 73 70 61 63 |or has m|ore spac|
|000052b0| 65 20 66 6f 72 20 66 6f | 72 6d 75 6c 61 73 0d 20 |e for fo|rmulas. |
|000052c0| 2d 20 46 6f 6c 6c 6f 77 | 73 20 69 6e 74 65 72 66 |- Follow|s interf|
|000052d0| 61 63 65 20 67 75 69 64 | 65 6c 69 6e 65 73 20 6d |ace guid|elines m|
|000052e0| 6f 72 65 20 63 6c 6f 73 | 65 6c 79 0d 20 2d 20 42 |ore clos|ely. - B|
|000052f0| 65 74 74 65 72 20 6d 65 | 6d 6f 72 79 20 6d 61 6e |etter me|mory man|
|00005300| 61 67 65 6d 65 6e 74 0d | 20 2d 20 59 6f 75 20 6e |agement.| - You n|
|00005310| 6f 20 6c 6f 6e 67 65 72 | 20 67 65 74 20 61 6e 20 |o longer| get an |
|00005320| 65 72 72 6f 72 20 77 68 | 65 6e 20 61 20 66 6f 72 |error wh|en a for|
|00005330| 6d 75 6c 61 20 68 61 73 | 20 73 70 61 63 65 73 20 |mula has| spaces |
|00005340| 6f 72 20 6c 6f 77 65 72 | 20 63 61 73 65 20 63 65 |or lower| case ce|
|00005350| 6c 6c 20 72 65 66 65 72 | 65 6e 63 65 73 0d 20 2d |ll refer|ences. -|
|00005360| 20 45 64 69 74 6f 72 20 | 6e 6f 77 20 73 68 6f 77 | Editor |now show|
|00005370| 73 20 61 20 70 65 72 69 | 6f 64 20 6f 72 20 61 20 |s a peri|od or a |
|00005380| 63 6f 6d 6d 61 2c 20 64 | 65 70 65 6e 64 69 6e 67 |comma, d|epending|
|00005390| 20 6f 6e 20 d2 4c 6f 63 | 61 6c 65 d3 20 73 65 74 | on .Loc|ale. set|
|000053a0| 74 69 6e 67 20 69 6e 20 | 74 68 65 20 70 72 65 66 |ting in |the pref|
|000053b0| 65 72 65 6e 63 65 73 0d | 20 2d 20 41 20 66 65 77 |erences.| - A few|
|000053c0| 20 64 69 73 70 6c 61 79 | 20 70 72 6f 62 6c 65 6d | display| problem|
|000053d0| 73 20 68 61 76 65 20 62 | 65 65 6e 20 66 69 78 65 |s have b|een fixe|
|000053e0| 64 0d 20 2d 20 46 69 78 | 65 64 20 61 20 62 75 67 |d. - Fix|ed a bug|
|000053f0| 20 74 68 61 74 20 6f 63 | 63 75 72 72 65 64 20 77 | that oc|curred w|
|00005400| 68 65 6e 20 64 6f 69 6e | 67 20 61 20 d2 46 69 6c |hen doin|g a .Fil|
|00005410| 6c d3 0d 20 2d 20 46 69 | 78 65 64 20 61 20 62 75 |l.. - Fi|xed a bu|
|00005420| 67 20 74 68 61 74 20 6f | 63 63 75 72 72 65 64 20 |g that o|ccurred |
|00005430| 77 68 65 6e 20 64 6f 69 | 6e 67 20 61 20 d2 53 55 |when doi|ng a .SU|
|00005440| 4d d3 0d 20 2d 20 46 69 | 78 65 64 20 61 20 62 75 |M.. - Fi|xed a bu|
|00005450| 67 20 74 68 61 74 20 77 | 61 73 20 6c 69 6e 6b 65 |g that w|as linke|
|00005460| 64 20 74 6f 20 74 68 65 | 20 73 63 72 6f 6c 6c 69 |d to the| scrolli|
|00005470| 6e 67 20 6f 66 20 61 20 | 73 68 65 65 74 0d 20 2d |ng of a |sheet. -|
|00005480| 20 44 65 6c 65 74 69 6e | 67 20 61 20 73 68 65 65 | Deletin|g a shee|
|00005490| 74 20 6e 6f 77 20 75 70 | 64 61 74 65 73 20 74 68 |t now up|dates th|
|000054a0| 65 20 6c 69 73 74 20 6f | 66 20 73 68 65 65 74 73 |e list o|f sheets|
|000054b0| 0d 0d 4e 61 70 6b 69 6e | 20 43 61 6c 63 20 31 2e |..Napkin| Calc 1.|
|000054c0| 30 3a 20 48 65 72 65 20 | 77 65 20 67 6f 21 0d 20 |0: Here |we go!. |
|000054d0| 2d 20 4e 6f 74 68 69 6e | 67 20 6e 65 77 2c 20 74 |- Nothin|g new, t|
|000054e0| 68 69 73 20 77 61 73 20 | 74 68 65 20 66 69 72 73 |his was |the firs|
|000054f0| 74 20 76 65 72 73 69 6f | 6e 21 0d 0d 0d 54 48 45 |t versio|n!...THE|
|00005500| 20 46 55 54 55 52 45 0d | 4f 66 20 63 6f 75 72 73 | FUTURE.|Of cours|
|00005510| 65 2c 20 77 65 20 61 6c | 72 65 61 64 79 20 68 61 |e, we al|ready ha|
|00005520| 76 65 20 73 6f 6d 65 20 | 69 64 65 61 73 20 66 6f |ve some |ideas fo|
|00005530| 72 20 66 75 74 75 72 65 | 20 76 65 72 73 69 6f 6e |r future| version|
|00005540| 73 2e 2e 2e 20 42 75 74 | 20 79 6f 75 72 20 69 64 |s... But| your id|
|00005550| 65 61 73 20 61 72 65 20 | 61 6c 73 6f 20 76 65 72 |eas are |also ver|
|00005560| 79 20 6d 75 63 68 20 77 | 65 6c 63 6f 6d 65 2e 20 |y much w|elcome. |
|00005570| 57 65 20 6c 6f 76 65 20 | 74 6f 20 68 65 61 72 20 |We love |to hear |
|00005580| 66 72 6f 6d 20 70 65 6f | 70 6c 65 20 74 68 61 74 |from peo|ple that|
|00005590| 20 75 73 65 20 6f 75 72 | 20 61 70 70 6c 69 63 61 | use our| applica|
|000055a0| 74 69 6f 6e 73 20 28 77 | 68 65 74 68 65 72 20 74 |tions (w|hether t|
|000055b0| 68 65 20 63 6f 6d 6d 65 | 6e 74 73 20 61 72 65 20 |he comme|nts are |
|000055c0| 70 6f 73 69 74 69 76 65 | 20 6f 72 20 6e 65 67 61 |positive| or nega|
|000055d0| 74 69 76 65 29 2e 20 53 | 6f 20 73 65 6e 64 20 69 |tive). S|o send i|
|000055e0| 6e 20 79 6f 75 72 20 69 | 64 65 61 73 20 69 66 20 |n your i|deas if |
|000055f0| 79 6f 75 20 68 61 76 65 | 20 61 6e 79 21 20 54 68 |you have| any! Th|
|00005600| 65 79 d5 6c 6c 20 62 65 | 20 67 72 65 61 74 6c 79 |ey.ll be| greatly|
|00005610| 20 61 70 70 72 65 63 69 | 61 74 65 64 2e 0d 0d 0d | appreci|ated....|
|00005620| 57 48 49 4c 45 20 57 45 | d5 52 45 20 41 54 20 49 |WHILE WE|.RE AT I|
|00005630| 54 0d 54 68 69 73 20 61 | 70 70 6c 69 63 61 74 69 |T.This a|pplicati|
|00005640| 6f 6e 20 69 73 20 73 68 | 61 72 65 77 61 72 65 2e |on is sh|areware.|
|00005650| 20 57 65 d5 76 65 20 70 | 75 74 20 61 20 6c 6f 74 | We.ve p|ut a lot|
|00005660| 20 6f 66 20 74 69 6d 65 | 20 69 6e 20 64 65 73 69 | of time| in desi|
|00005670| 67 6e 69 6e 67 20 74 68 | 69 73 2c 20 61 6e 64 20 |gning th|is, and |
|00005680| 70 6c 61 6e 20 74 6f 20 | 70 75 74 20 6d 6f 72 65 |plan to |put more|
|00005690| 20 74 69 6d 65 20 69 6e | 20 69 74 20 73 74 69 6c | time in| it stil|
|000056a0| 6c 2e 20 59 6f 75 20 6d | 61 79 20 75 73 65 20 69 |l. You m|ay use i|
|000056b0| 74 20 66 6f 72 20 66 72 | 65 65 20 66 6f 72 20 31 |t for fr|ee for 1|
|000056c0| 35 20 64 61 79 73 2c 20 | 62 75 74 20 69 66 20 79 |5 days, |but if y|
|000056d0| 6f 75 20 70 6c 61 6e 20 | 6f 6e 20 75 73 69 6e 67 |ou plan |on using|
|000056e0| 20 69 74 20 61 66 74 65 | 72 20 74 68 61 74 20 70 | it afte|r that p|
|000056f0| 65 72 69 6f 64 20 28 65 | 69 74 68 65 72 20 66 6f |eriod (e|ither fo|
|00005700| 72 20 70 65 72 73 6f 6e | 61 6c 20 75 73 65 2c 20 |r person|al use, |
|00005710| 6f 72 20 66 6f 72 20 62 | 75 73 69 6e 65 73 73 29 |or for b|usiness)|
|00005720| 2c 20 79 6f 75 20 6d 75 | 73 74 20 72 65 67 69 73 |, you mu|st regis|
|00005730| 74 65 72 20 74 68 65 20 | 61 70 70 6c 69 63 61 74 |ter the |applicat|
|00005740| 69 6f 6e 20 61 6e 64 20 | 73 65 6e 64 20 24 32 35 |ion and |send $25|
|00005750| 20 74 6f 20 74 68 65 20 | 66 6f 6c 6c 6f 77 69 6e | to the |followin|
|00005760| 67 20 61 64 64 72 65 73 | 73 3a 20 28 43 61 6e 61 |g addres|s: (Cana|
|00005770| 64 69 61 6e 20 61 6e 64 | 20 51 75 65 62 65 63 20 |dian and| Quebec |
|00005780| 72 65 73 69 64 65 6e 74 | 73 2c 20 61 64 64 20 47 |resident|s, add G|
|00005790| 53 54 20 61 6e 64 20 50 | 53 54 29 2e 0d 0d 4d 61 |ST and P|ST)...Ma|
|000057a0| 63 61 70 61 20 53 6f 66 | 74 77 61 72 65 0d 34 34 |capa Sof|tware.44|
|000057b0| 30 20 55 70 70 65 72 20 | 45 64 69 73 6f 6e 20 23 |0 Upper |Edison #|
|000057c0| 37 0d 53 74 2d 4c 61 6d | 62 65 72 74 0d 51 75 65 |7.St-Lam|bert.Que|
|000057d0| 62 65 63 2c 20 43 41 4e | 41 44 41 0d 4a 34 52 20 |bec, CAN|ADA.J4R |
|000057e0| 32 56 35 0d 0d 50 6c 65 | 61 73 65 20 69 6e 63 6c |2V5..Ple|ase incl|
|000057f0| 75 64 65 20 79 6f 75 72 | 20 6e 61 6d 65 2c 20 61 |ude your| name, a|
|00005800| 64 64 72 65 73 73 2c 20 | 70 68 6f 6e 65 20 6e 75 |ddress, |phone nu|
|00005810| 6d 62 65 72 20 61 6e 64 | 20 61 6e 20 45 2d 4d 61 |mber and| an E-Ma|
|00005820| 69 6c 20 61 64 64 72 65 | 73 73 20 77 68 65 72 65 |il addre|ss where|
|00005830| 20 77 65 20 63 61 6e 20 | 72 65 61 63 68 20 79 6f | we can |reach yo|
|00005840| 75 2e 20 49 66 20 79 6f | 75 20 68 61 76 65 20 61 |u. If yo|u have a|
|00005850| 6e 20 45 2d 4d 61 69 6c | 20 61 64 64 72 65 73 73 |n E-Mail| address|
|00005860| 2c 20 79 6f 75 20 77 69 | 6c 6c 20 72 65 63 65 69 |, you wi|ll recei|
|00005870| 76 65 20 79 6f 75 72 20 | 75 73 65 72 20 49 44 20 |ve your |user ID |
|00005880| 6e 75 6d 62 65 72 20 74 | 68 65 20 64 61 79 20 77 |number t|he day w|
|00005890| 65 20 67 65 74 20 79 6f | 75 72 20 63 68 65 63 6b |e get yo|ur check|
|000058a0| 2e 20 49 66 20 79 6f 75 | 20 64 6f 6e d5 74 20 68 |. If you| don.t h|
|000058b0| 61 76 65 20 6f 6e 65 2c | 20 79 6f 75 20 77 69 6c |ave one,| you wil|
|000058c0| 6c 20 72 65 63 65 69 76 | 65 20 74 68 65 20 75 73 |l receiv|e the us|
|000058d0| 65 72 20 49 44 20 62 79 | 20 72 65 67 75 6c 61 72 |er ID by| regular|
|000058e0| 20 6d 61 69 6c 2e 0d 0d | 4f 6e 63 65 20 79 6f 75 | mail...|Once you|
|000058f0| 20 72 65 67 69 73 74 65 | 72 20 66 6f 72 20 4e 61 | registe|r for Na|
|00005900| 70 6b 69 6e 20 43 61 6c | 63 2c 20 79 6f 75 20 61 |pkin Cal|c, you a|
|00005910| 72 65 20 63 6f 6e 73 69 | 64 65 72 65 64 20 72 65 |re consi|dered re|
|00005920| 67 69 73 74 65 72 65 64 | 20 66 6f 72 20 61 6c 6c |gistered| for all|
|00005930| 20 76 65 72 73 69 6f 6e | 73 20 74 6f 20 63 6f 6d | version|s to com|
|00005940| 65 2e 0d 0d 54 68 61 6e | 6b 20 79 6f 75 2e 0d 0d |e...Than|k you...|
|00005950| 0d 50 53 3a 20 54 68 69 | 73 20 61 70 70 6c 69 63 |.PS: Thi|s applic|
|00005960| 61 74 69 6f 6e 20 69 73 | 20 43 6f 70 79 72 69 67 |ation is| Copyrig|
|00005970| 68 74 65 64 20 a9 20 74 | 6f 20 4c 65 73 20 6c 6f |hted . t|o Les lo|
|00005980| 67 69 63 69 65 6c 73 20 | 4d 61 63 61 70 61 2e 20 |giciels |Macapa. |
|00005990| 49 74 20 6d 61 79 20 62 | 65 20 64 69 73 74 72 69 |It may b|e distri|
|000059a0| 62 75 74 65 64 20 66 72 | 65 65 6c 79 20 66 6f 72 |buted fr|eely for|
|000059b0| 20 6e 6f 6e 2d 63 6f 6d | 6d 65 72 63 69 61 6c 20 | non-com|mercial |
|000059c0| 70 75 72 70 6f 73 65 73 | 20 28 61 73 20 6c 6f 6e |purposes| (as lon|
|000059d0| 67 20 61 73 20 74 68 69 | 73 20 64 6f 63 75 6d 65 |g as thi|s docume|
|000059e0| 6e 74 61 74 69 6f 6e 20 | 69 73 20 69 6e 63 6c 75 |ntation |is inclu|
|000059f0| 64 65 64 2c 20 75 6e 63 | 68 61 6e 67 65 64 29 2e |ded, unc|hanged).|
|00005a00| 20 52 69 67 68 74 73 20 | 61 72 65 20 72 65 73 65 | Rights |are rese|
|00005a10| 72 76 65 64 20 62 79 20 | 74 68 65 20 61 75 74 68 |rved by |the auth|
|00005a20| 6f 72 2e 0d 00 00 00 00 | 00 00 00 00 00 00 00 00 |or......|........|
|00005a30| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005a40| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005a50| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005a60| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005a70| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005a80| 00 00 01 00 00 00 01 1a | 00 00 00 1a 00 00 00 32 |........|.......2|
|00005a90| 00 04 00 00 00 08 00 00 | 00 00 00 75 00 04 00 00 |........|...u....|
|00005aa0| 00 02 00 00 00 00 00 d3 | 00 04 00 00 00 02 00 00 |........|........|
|00005ab0| 13 4e 61 70 6b 69 6e 20 | 43 61 6c 63 20 52 45 41 |.Napkin |Calc REA|
|00005ac0| 44 20 4d 45 02 00 00 00 | 50 61 72 74 53 49 54 21 |D ME....|PartSIT!|
|00005ad0| 00 00 50 61 72 74 53 49 | 54 21 00 00 00 00 00 00 |..PartSI|T!......|
|00005ae0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005af0| 00 00 aa 6d 5a 12 00 00 | 00 00 00 00 01 4c 00 00 |...mZ...|.....L..|
|00005b00| 00 02 00 00 00 00 00 70 | 00 04 00 00 00 02 00 00 |.......p|........|
|00005b10| 00 00 00 46 00 04 00 00 | 00 03 00 00 00 00 00 45 |...F....|.......E|
|00005b20| 00 04 00 00 00 03 00 00 | 00 00 00 4a 00 04 00 00 |........|...J....|
|00005b30| 00 04 00 00 00 00 00 31 | 00 04 00 00 00 05 00 00 |.......1|........|
|00005b40| 00 00 00 2f 00 04 00 00 | 00 04 00 00 00 00 00 47 |.../....|.......G|
|00005b50| 00 04 00 00 00 17 00 00 | 00 00 00 ad 00 04 00 00 |........|........|
|00005b60| 00 04 00 00 00 00 00 04 | 00 04 00 00 00 04 00 00 |........|........|
|00005b70| 00 00 00 04 00 04 00 00 | 00 04 00 00 00 00 00 04 |........|........|
|00005b80| 00 00 00 16 00 01 00 00 | 00 00 00 10 00 0c 00 03 |........|........|
|00005b90| 00 00 00 0c 00 00 00 00 | 00 00 00 00 01 00 00 00 |........|........|
|00005ba0| 01 1a 00 00 00 1a 00 00 | 00 32 00 56 d5 18 12 5e |........|.2.V...^|
|00005bb0| 00 00 00 1c 00 32 00 00 | 73 74 79 6c 00 00 00 0a |.....2..|styl....|
|00005bc0| 00 80 ff ff 00 00 00 00 | 00 57 31 64 00 00 00 00 |........|.W1d....|
|00005bd0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005be0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005bf0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
+--------+-------------------------+-------------------------+--------+--------+
